Message-ID: <005f01c0b5ec$f2515660$1001a8c0@archonet.com>
From: "Richard Huxton" <dev@archonet.com>
To: "Norbert Schollum" <schollum@equinux.de>, <pgsql-sql@postgresql.org>
References: <3ABF0AD3.9F117AAF@equinux.de>
Subject: Re: Functions and Triggers
Date: Mon, 26 Mar 2001 13:04:41 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

From: "Norbert Schollum" <schollum@equinux.de>
To: <pgsql-sql@postgresql.org>
Sent: Monday, March 26, 2001 10:24 AM
Subject: [SQL] Functions and Triggers


> Hello there!
>
> here is what i want to realize:
>
> a trigger, that puts a now() in the last_updated field, on any update of
> that table.
>
> i read the manual but i wasnt able to make a working function.
> what is the return value here? is there any or is it void?

"opaque" - a special value for triggers.

> has somebody a example for me that is similary to my problem?

Yep - see the postgres notes from techdocs.postgresql.org - I've got an
example there of exactly this (it's in the "automating" chapter - sorry,
forget the precise URL)

Also have a look at the Cookbook (linked to from same place) which might
well have more examples.

- Richard Huxton