On Tue, 21 Sep 1999, Thomas Lockhart wrote:
> Date: Tue, 21 Sep 1999 06:14:12 +0000
> From: Thomas Lockhart <lockhart@alumni.caltech.edu>
> To: Mike Mascari <mascarim@yahoo.com>
> Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] create table and default 'now' problem ?
>
> > > 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',...)
>
This works ! Thanks
> or
>
> create table test ( a datetime default 'now'::text,...)
Parser complains:
ERROR: parser: parse error at or near "'"
Does this considered as a bug or feature ?
Oleg
>
> 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@alumni.caltech.edu
> South Pasadena, California
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
