[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [GNUe] postgresql.sql in pre-release

From: Jason Cater
Subject: Re: [GNUe] postgresql.sql in pre-release
Date: Sat, 21 Feb 2004 09:56:45 -0600
User-agent: KMail/1.6


I'm not PostgreSQL expert, so someone correct me if I'm wrong. 

My understanding is that, as of PostgreSQL 7.0, "timestamp" is the official 
datatype for "date with time". This was to bring PgSQL in line with SQL-92 
standard namespace. 

"datetime" was marked as deprecated in 7.0 and was officially removed in 7.3.

I imagine the original poster of this email is using 7.3+ and you are using 
7.2 (from Woody). 

This change hit a lot of us when we upgraded from Woody :(

-- Jason 

On Saturday 21 February 2004 02:21 am, Johannes Vetter wrote:
> I'm using PostgreSQL 7.2.1 and 'datetime' worked well for me, so I did
> not thought about it when creating the gsd-processor.
> So, what is the official datatype for "date with time" in PostgreSQL
> now?
> Johannes

reply via email to

[Prev in Thread] Current Thread [Next in Thread]