Postgres Pro
Downloads
Home   >   mailing lists

Re: I was spoiled by the MySQL timestamp field - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: I was spoiled by the MySQL timestamp field
Date
Msg-id 5.1.0.14.1.20030124174614.0283b6c0@mbox.jaring.my
Whole thread Raw
In response to Re: I was spoiled by the MySQL timestamp field  ("Matthew Nuzum" <cobalt@bearfruit.org>)
Responses Re: I was spoiled by the MySQL timestamp field  ("Matthew Nuzum" <cobalt@bearfruit.org>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: 7.2.1: coalesce double-calls function?
Next
From: "frank_lupo"
Date:
Subject: pid in pg_locks not present in procpid pg_stat_activity