From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Mike Mascari <mascarim(at)yahoo(dot)com> |
Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] create table and default 'now' problem ? |
Date: | 1999-09-21 06:14:12 |
Message-ID: | 37E72234.DDA960FE@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > how I could create table with datetime field default
> > to 'now'::text in a way Jan did in his shoes rule example ?
> > If I do:
> > test=> create table test ( a datetime default 'now',
> > b int4);
> > CREATE
> > I always get datetime of the moment I created the
> > table, but I'd like to have datetime of moment I insert.
> One way around this bug is to create a SQL function
> which returns now() and use it as the default value:
Not necessary, though this does work well. A simpler way is to
actually do what Oleg asks about:
create table test ( a datetime default text 'now',...)
or
create table test ( a datetime default 'now'::text,...)
which should force the string to *stay* as a string, rather than
getting converted to a date value when the table is created. Once it
is forced to be a string, then it will be converted at insert time
instead.
- Thomas
--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1999-09-21 06:14:40 | Re: [HACKERS] Re: HISTORY for 6.5.2 |
Previous Message | The Hermit Hacker | 1999-09-21 06:03:58 | Re: [HACKERS] create table and default 'now' problem ? |