From: "Norbert Schollum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
