Thread: timestamp column default changed?
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? Is this right? -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ---------------------------------- A wiki we will go...
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
-- 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
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...
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
I understand. Thanks for pointing that out. L. On Wed, 11 Sep 2002, Bruce Momjian wrote: > > 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... > > > > > > -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ---------------------------------- A wiki we will go...
timestamp becoming timestamp without time zone is actually the SQL standard... Chris > 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... > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >