"Julian Scarfe" <[EMAIL PROTECTED]> writes: > The timezone on our boxes is set to Etc/UCT (possibly a distro default). > (psql 8.1.4)
> => select to_char(current_timestamp, 'HH24:MI:SS TZ'); > to_char > -------------- > 09:05:48 UCT > (1 row) > => select '09:05:48 UCT'::time; > ERROR: invalid input syntax for type time: "09:05:48 UCT" This works in CVS HEAD, thanks to some hard work by Joachim Wieland. http://archives.postgresql.org/pgsql-patches/2006-07/msg00077.php http://archives.postgresql.org/pgsql-committers/2006-07/msg00258.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match