current_time? - Mailing list pgsql-hackers

From Vince Vielhaber
Subject current_time?
Date
Msg-id XFMail.991019220533.vev@michvhf.com
Whole thread Raw
Responses Re: [HACKERS] current_time?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Now I thought this was discussed recently and this:

create table foo(
x       int,
y       datetime default current_time);

would put the current date and time into y whenever a new record was
inserted.  It appears to give the date and time the stupid table was
created.  Is it me or is something broke?

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null # include <std/disclaimers.h>       Have you
seenhttp://www.pop4.net?       Online Campground Directory    http://www.camping-usa.com      Online Giftshop
Superstore   http://www.cloudninegifts.com
 
==========================================================================




pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] book
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] mdnblocks is an amazing time sink in huge relations