Greg,
> This seem rather limiting... Suppose I want a trigger that after insert,
> returns the currval(sequence) of the newly inserted row automatically
> without having to run another query ???
Because you can't capture the return value of a trigger. The trigger is
returning the new/altered/deleted row.
If you want a function to return a value, don't use a trigger.
--
-Josh Berkus
Aglio Database Solutions
San Francisco