Re: [GENERAL] time type strange behaviour

2006-10-14 Thread Michael Fuhr
On Tue, Oct 10, 2006 at 05:16:14PM +0100, garry saddington wrote: > On Tue, 2006-10-10 at 11:58 -0400, Tom Lane wrote: > > garry saddington <[EMAIL PROTECTED]> writes: > > > This definition does not insert time zone. If I use without time zone > > > then the time zone is inserted. > > > If I input

Re: [GENERAL] time type strange behaviour

2006-10-10 Thread garry saddington
On Tue, 2006-10-10 at 11:58 -0400, Tom Lane wrote: > garry saddington <[EMAIL PROTECTED]> writes: > > I have the following table def. > > CREATE TABLE periods > > ( > > periodid serial NOT NULL, > > periodnumber integer NOT NULL, > > periodstart time with time zone, > > periodend time with

Re: [GENERAL] time type strange behaviour

2006-10-10 Thread Tom Lane
garry saddington <[EMAIL PROTECTED]> writes: > I have the following table def. > CREATE TABLE periods > ( > periodid serial NOT NULL, > periodnumber integer NOT NULL, > periodstart time with time zone, > periodend time with time zone, > PRIMARY KEY (periodid) > ) > This definition does n

[GENERAL] time type strange behaviour

2006-10-10 Thread garry saddington
I have the following table def. CREATE TABLE periods ( periodid serial NOT NULL, periodnumber integer NOT NULL, periodstart time with time zone, periodend time with time zone, PRIMARY KEY (periodid) ) This definition does not insert time zone. If I use without time zone then the time z