Re: [SQL] Adding a rule to update a last_changed field

> > I'm trying to use a rule to maintain a last_changed field.
>
> Use a trigger, not a rule. You can adjust the last_changed
> field before the tuple is stored that way. There's an example
> in the manual's discussion of triggers.

My original choice was to use a trigger, but I don't want to introduce
C code when I don't have to. I don't believe that making external calls
should be necessary for a query that can be so simply expressed in SQL.

And from the manual:
"The procedure name is the C function called"

If triggers can use SQL, I'd be happy to use them, but I can't find a single
example or description on how to do this.