From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] current_timestamp and default now() |
Date: | 1999-10-26 14:19:32 |
Message-ID: | 4.2.0.58.19991026111838.0098af00@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I believe it works if you put now() in single quotes. EG:
create table test (
proposetime datetime not null default 'now()',
)
At 10:07 PM 10/25/99, Lincoln Yeoh wrote:
>At 01:05 PM 25-10-1999 PDT, amy cheng wrote:
> >hi, there,
> >
> >I'm using:
> >
> >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?
>
>Cheerio,
>
>Link.
>
>
>************
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Mercer | 1999-10-26 14:42:34 | Re: [GENERAL] initdb error->ld-elf.so.1: Shared object "libpq.so.2" not found^H |
Previous Message | Ken Loomis | 1999-10-26 12:29:07 | Re: Pool Cues and Billiards Accessories 8096 |