Re: the behaviour of timestamp on postgres.

From: Prabu Subroto <prabu_subroto(at)yahoo(dot)com>
To: Postgres General Milis <pgsql-general(at)postgresql(dot)org>
Subject: Re: the behaviour of timestamp on postgres.
Date: 2004-08-11 14:47:35
Message-ID: 20040811144735.61053.qmail@web41809.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It's solved.

Thank you very much, Doug.

Thanks.
--- Doug McNaught <doug(at)mcnaught(dot)org> wrote:

> Prabu Subroto <prabu_subroto(at)yahoo(dot)com> writes:
>
> > How can I make the postgres complete the value of
> the
> > timestamp field automatically?
>
> Add a DEFAULT NOW() clause to the column definition.
>
>
> -Doug
> --
> Let us cross over the river, and rest under the
> shade of the trees.
> --T. J. Jackson, 1863
>


__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-11 15:03:07 Re: POSIX RE starting with a (
Previous Message Sebastian Böck 2004-08-11 14:47:27 Re: the behaviour of timestamp on postgres.