Re: on update set default

From: rolf(dot)ostvik(at)axxessit(dot)no
To: pgsql-general(at)postgresql(dot)org
Subject: Re: on update set default
Date: 2001-12-10 08:08:08
Message-ID: OF9D668014.8DBD83C7-ONC1256B1E.002C27EA@axxessit.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2001-12-09 "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> wrote:
>Im want that on each insert, update to a table the column:
>changed_on TIMESTAMP DEFAULT now()
>will be set to now();

In the PostgreSQL 7.1 Programmer's guide

http://www.postgresql.org/idocs/index.php?plpgsql-trigger.html

I guess it's more than you need.

--
AXXESSIT ASA http://www.axxessit.no
Rolf Østvik / Test technician

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-12-10 10:14:54 Re: DEBUG messages
Previous Message Tom Lane 2001-12-10 04:53:11 Re: Multiple Instances