create table and default 'now' problem ? - Mailing list pgsql-hackers

From Oleg Bartunov
Subject create table and default 'now' problem ?
Date
Msg-id Pine.GSO.3.96.SK.990921014729.24490A-100000@ra
Whole thread Raw
List pgsql-hackers
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

_____________________________________________________________
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



pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Command Locations (was Re: HISTORY for 6.5....)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] pgaccess seems a tad confused]