"Ed L." <[EMAIL PROTECTED]> writes:
> Note the queries below generate the same result regardless of the timezone
> input:
This isn't a bug. Per documentation:
: For timestamp [without time zone], any explicit time zone specified in
: the input is silently ignored. That is, the resulting date/time value is
: derived from the explicit date/time fields in the input value, and is
: not adjusted for time zone.
You want to use timestamp with time zone (timestamptz), I think.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
