> ... 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;
