Re: timestamp column default changed? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: timestamp column default changed?
Date
Msg-id 200209112330.g8BNU1m04272@candle.pha.pa.us
Whole thread Raw
In response to Re: timestamp column default changed?  (Laurette Cisneros <laurette@nextbus.com>)
Responses Re: timestamp column default changed?  (Laurette Cisneros <laurette@nextbus.com>)
List pgsql-hackers
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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: problem with new autocommit config parameter and jdbc
Next
From: Bruce Momjian
Date:
Subject: Re: