psql -c "select current_date from dual;" (where dual is some existing table of course..) works fine in RH5.1/i386 but in RH5.2/Alpha it reports odd dates. (not tried on RH5.2/i386's postgresql but I bet this is some axp/64-bit problem.)
I have verified this to be true on a standard 5.2 install to a PC164LX alpha. psql -d test -c "select current_date from foo"; psql -d test -c "select current_time from foo"; Both lines print strange dates and times.
postgresql-6.4.2 (and 6.5.0beta1) are broken on alpha and have been removed from the Red Hat 6.0 distribution. We will distribute a version of postgresql for alpha as soon as we can find one that works.
postgresql-6.5.1.beta1 is available in Rawhide-1.4.1 on the rawhide ftp site.