Re: [HACKERS] create table and default 'now' problem ? - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: [HACKERS] create table and default 'now' problem ?
Date
Msg-id Pine.BSF.4.10.9909210302340.38923-100000@thelab.hub.org
Whole thread Raw
In response to Re: [HACKERS] create table and default 'now' problem ?  (Mike Mascari <mascarim@yahoo.com>)
List pgsql-hackers
Ignore last...I hadn't clued into the 'same time as table created' part of
his message...

Thomas...is that not a 'bug' with the datetime/timestamp handling of
DEFAULT? *raised eyebrow*



On Mon, 20 Sep 1999, Mike Mascari wrote:

> One way around this bug is to create a SQL function
> which returns now() and use it as the default value:
> 
> 1. create function mynow() returns datetime
>    as 'SELECT now()::datetime' LANGUAGE 'SQL';
> 
> 2. create table test (a datetime default mynow(), b   
> int4);
> 
> Now things should work:
> 
> insert into test (b) values (1);
> insert into test (b) values (2);
> 
> select * from test;
> a                           |b
> ----------------------------+-
> Tue Sep 21 01:05:02 1999 EDT|1
> Tue Sep 21 01:05:08 1999 EDT|2
> (2 rows)                       
> 
> Hope this helps, 
> 
> Mike Mascari
> (mascarim@yahoo.com)
> 
> --- Oleg Bartunov <oleg@sai.msu.su> wrote:
> > Hi,
> > 
> > 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
> > test=> insert into test (b) values (1);
> > INSERT 1677899 1
> > test=> insert into test (b) values (2);
> > INSERT 1677900 1
> > test=> select * from test;
> > a                           |b
> > ----------------------------+-
> > Tue 21 Sep 01:48:27 1999 MSD|1
> > Tue 21 Sep 01:48:27 1999 MSD|2
> > (2 rows)
> > 
> > I always get datetime of the moment I created the
> > table, but I'd like
> > to have datetime of moment I insert. 
> > 
> >     Regards,
> > 
> >         Oleg
> > 
> __________________________________________________
> Do You Yahoo!?
> Bid and sell for free at http://auctions.yahoo.com
> 
> ************
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Re: HISTORY for 6.5.2
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] create table and default 'now' problem ?