Re: Inserting timestamp values - Mailing list pgsql-docs

From Tom Lane
Subject Re: Inserting timestamp values
Date
Msg-id 17289.1070383257@sss.pgh.pa.us
Whole thread Raw
In response to Inserting timestamp values  ("cnliou" <cnliou@so-net.net.tw>)
Responses Re: Inserting timestamp values  (Hannu Krosing <hannu@tm.ee>)
List pgsql-docs
"cnliou" <cnliou@so-net.net.tw> 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 to timestamp with time zone.

            regards, tom lane

pgsql-docs by date:

Previous
From: "cnliou"
Date:
Subject: Inserting timestamp values
Next
From: Hannu Krosing
Date:
Subject: Re: Inserting timestamp values