Re: [HACKERS] create table and default 'now' problem ?

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