Re: timestamp column default changed?
| От | Christopher Kings-Lynne |
|---|---|
| Тема | Re: timestamp column default changed? |
| Дата | |
| Msg-id | GNELIHDDFBOCMGBFGEFOKEDDCEAA.chriskl@familyhealth.com.au обсуждение исходный текст |
| Ответ на | Re: timestamp column default changed? (Laurette Cisneros <laurette@nextbus.com>) |
| Список | pgsql-hackers |
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 >
В списке pgsql-hackers по дате отправления: