Re: I was spoiled by the MySQL timestamp field

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: "Matthew Nuzum" <cobalt(at)bearfruit(dot)org>, "'Björn Metzdorf'" <bm(at)turtle-entertainment(dot)de>, "'Alan T(dot) Miller'" <amiller(at)hollywood101(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: I was spoiled by the MySQL timestamp field
Date: 2003-01-24 09:47:14
Message-ID: 5.1.0.14.1.20030124174614.0283b6c0@mbox.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 03:02 PM 1/23/03 -0500, Matthew Nuzum wrote:

>One word of caution, I *think* you want quotes around the 'now()'
>statement in your table definition. Otherwise your default value will be
>the instant the *table* was created, not the instant your insert
>happened.

Would plain: default 'now' work? If it does (it seems to), what is the
difference?

Link.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message frank_lupo 2003-01-24 10:04:07 pid in pg_locks not present in procpid pg_stat_activity
Previous Message SZŰCS Gábor 2003-01-24 08:58:18 7.2.1: coalesce double-calls function?