Re: Date column that defaults to 'now'

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: John Siracusa <siracusa(at)mindspring(dot)com>
Subject: Re: Date column that defaults to 'now'
Date: 2004-01-06 22:09:02
Message-ID: 3FFB31FE.8000106@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Siracusa wrote:

> On 1/5/04 4:29 PM, Michael Glaesemann wrote:
>
>>(If you're not the John Siracusa who writes for Ars Technica, the
>>sentiment still holds. :) )
>
>
> I am everywhere!
>
> (worked, thanks to both of you who replied :)

Anyway the two solution solve different problems:

1) DEFAULT now()
you'll have the timestamp of transaction

2) DEFAULT timeofday()
you'll have the timestamp of insertion

Regards
Gaetano Mendola

In response to

Browse pgsql-general by date

  From Date Subject
Next Message keith 2004-01-06 22:09:38 Re: Paypal WAS: PostgreSQL speakers needed for OSCON
Previous Message Adam Ruth 2004-01-06 22:06:42 Re: DBs and Schemas