Horton

Re: I was spoiled by the MySQL timestamp field

Lincoln Yeoh <lyeoh@pop.jaring.my>

View thread View on postgr.es
From: Lincoln Yeoh <lyeoh@pop.jaring.my>
To: "Matthew Nuzum" <cobalt@bearfruit.org>, "'Björn Metzdorf'" <bm@turtle-entertainment.de>, "'Alan T. Miller'" <amiller@hollywood101.com>, <pgsql-general@postgresql.org>
Date: 2003-01-24T09:47:14Z
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.