Re: [SQLObject] Preparing for 0.4

[David M. C. <da...@da...>]

On Wed, Apr 23, 2003 at 07:36:39AM -0500, Mike Hostetler wrote:

> In PostgreSQL < 7.3, 'datetime' is the same as 'timestamp'.  In
> PostgreSQL >= 7.3, it has been depreicated.

Ah, so it does do something for a lot of people (e.g. RH 8 has PG 7.2 AFAIK),
and it looks like it does the right thing in that case:

class DateTimeCol(Col):

    # 3-03 @@: provide constraints; right now we let the database
    # do any parsing and checking.  And DATE and TIME?

    def _mysqlType(self):
        return 'DATETIME'

    def _postgresType(self):
        return 'TIMESTAMP'
	
Dave