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... ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
