Thank you! Tom,
>The documentation does not actually say any such thing,
although its
>failure to clarify what it *is* saying isn't great. I have
reworded it
>as follows in CVS tip:
>
>: Table B-4 shows the time zone abbreviations recognized by
PostgreSQL in
>: date/time input values. PostgreSQL uses internal tables
for time zone
>: input decoding, since there is no standard operating
system interface to
>: provide access to general, cross-time zone information.
The underlying
>: operating system is used to provide time zone information
for output,
>: however.
>:
>: Keep in mind also that the time zone names recognized by
SET TIMEZONE
>: are operating-system dependent and may have little to do
with Table
>: B-4. For example, some systems recognize values like
'Europe/Rome' in
>: SET TIMEZONE.
>
>We do not make any attempt to document what timezone names
are accepted
>by SET TIMEZONE, because there is in general no way to find
out :-(
So, what is the official syntax? Is it like the following?
SET TIME ZONE TO 8:30
SET TIMEZONE TO 8:30
SET TIME ZONE TO -5
SET TIMEZONE TO -5
Regards,
CN