From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | webmaster(at)L-I-E(dot)com |
Cc: | teo(at)flex(dot)ro, Postgres Hackers List <hackers(at)postgresql(dot)org> |
Subject: | Re: Default 'now' |
Date: | 1998-08-07 05:23:36 |
Message-ID: | 35CA8F58.3303B8AE@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> ... 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;
From | Date | Subject | |
---|---|---|---|
Next Message | David Gould | 1998-08-07 05:58:40 | Re: [HACKERS] indexes and floats |
Previous Message | Vadim Mikheev | 1998-08-07 05:13:06 | Re: [HACKERS] indexes and floats |