Re: Assigning a timestamp without timezone to a timestamp

chrisj <chrisj.wood@sympatico.ca> writes:
> Did not seem to help:
> ERROR:  invalid input syntax for type timestamp with time zone: "2006-07-13
> 09:20:00 America/New_York"

Sorry, I was thinking in terms of CVS HEAD ... the ability to use a full
timezone spec in timestamptz input is new for 8.2.  You might be able to
use this, which does work in 8.1:

select '2006-07-13 09:20:00'::timestamp at time zone 'EST5EDT';   
        regards, tom lane