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
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
postgresql-6.5.1.beta1 is available in Rawhide-1.4.1 on the rawhide