Re: timestamp column default changed?

I think the SQL standards required the change.

---------------------------------------------------------------------------

Laurette Cisneros wrote:
> I'm sure you all have discussed this ad-nauseum but this sure does create a
> pain in the butt when converting.
>
> Ok, I had my say.
>
> Thanks for all your hard work,
>
> L.
> On Wed, 11 Sep 2002, Bruce Momjian wrote:
>
> > Laurette Cisneros wrote:
> > >
> > > If you define a column as:
> > > col timestamp
> > > In 7.2.x didn't it default to timestamp with timezone?
> > >
> > > And now in 7.3(b1) it defaults to timestamp without timezone?
> >
> > /HISTORY says right at the top:
> >
> > * TIMESTAMP and TIME data types now default to WITHOUT TIMEZONE
> >
> >
>
> --
> Laurette Cisneros
> The Database Group
> (510) 420-3137
> NextBus Information Systems, Inc.
> www.nextbus.com
> ----------------------------------
> A wiki we will go...
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073