Hi!
Does my test result comply with the statements in section
"8.5 Date/Time Types"? My shell set local time to UTC+8
hours. I was in the impression that the query
insert into test values ('2003-2-1'::timestamp);
equals to
insert into test values ('2003-2-1'::timestamp without time
zone);
b
"cnliou" <[EMAIL PROTECTED]> writes:
> Does my test result comply with the statements in section
> "8.5 Date/Time Types"?
I think so. You are inserting into a timestamp-with-time-zone column,
so even though you mark the literal constant as timestamp without time
zone, it's going to be converted
Tom Lane kirjutas T, 02.12.2003 kell 18:40:
> "cnliou" <[EMAIL PROTECTED]> writes:
> > Does my test result comply with the statements in section
> > "8.5 Date/Time Types"?
>
> I think so. You are inserting into a timestamp-with-time-zone column,
> so even though you mark the literal constant as
