"Geok Hua Yap" <geokhua8888@yahoo.com.sg> writes:
> select timeofday()::timestamp;
> ERROR: invalid input syntax for type timestamp: "Thu Oct 22 15:16:25.113963
> 2009 SGT"
SGT was added to the default set of timezone abbreviations as of 8.4.
If you want to use Singapore timezone in 8.3, you'll probably want to
add it to your local copy of that configuration file. See
http://www.postgresql.org/docs/8.3/static/datetime-config-files.html
regards, tom lane