Re: Default 'now'

> ... and what worked for me was:  default (datetime(now())
>
> So, the reason I'm annoying you now is this:  For some time now, I've
> been wondering what version of PostgreSQL my ISP has running.  He's
> never answered that particular query, and the version files are not
> readable by lowly me.
>
> So, can you tell me in what version of PostgreSQL this worked/broke?

postgres=> create table t (i int,
postgres-> d datetime default datetime(text 'now'));
CREATE

Works now. Have you tried

postgres=> select version();
version
--------------------------------------------------------------
PostgreSQL 6.4.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.1
(1 row)

The CVS log shows something was added back in 1996. Don't know if it
actually worked back then though...
revision 1.1
date: 1996/08/28 01:57:23;  author: scrappy;