At 01:05 PM 25-10-1999 PDT, amy cheng wrote:
>create table test (
>proposetime datetime not null default now(),
>then, I find that I need to make the time uniform through the
>transaction. Is there a way to use current_timestamp('now')
>in the create table statement? Seems impossible?
How about reading off the current time (select <somethingblahblah> 'now', I
can't remember how to do it- not very obvious at first sight) and then
using that time throughout the transaction?
In response to
pgsql-general by date
|Next:||From: Vadim Mikheev||Date: 1999-10-26 02:00:24|
|Subject: Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?|
|Previous:||From: Tatsuo Ishii||Date: 1999-10-26 00:59:49|
|Subject: Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL? |