Re: time type strange behaviour

On Tue, 2006-10-10 at 11:58 -0400, Tom Lane wrote:
> garry saddington <garry@schoolteachers.co.uk> 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 not insert time zone. If I use without time zone
> > then the time zone is inserted.
> > If I input a time like: 01:05 AM then on select I get something like:
> > 1970/01/01 01:05:00:00.
>
> Better look again --- if you get that output, the column is most
> certainly not a time column --- it must be timestamp.  Perhaps you
> got confused about which table is which?
>
>             regards, tom lane
No, there is no confusion, I have dropped it, re-made it and tested it
again, same result. I know it sounds odd but this is what happens!
Garry