Is there an equivalent to Oracle's INSERT ... RETURNING? Note that there is a related discussion in the archives about getting the auto-incremented id, but that doesn't cover the more general case of wanting to retrieve a value that has been altered by a trigger into a variable.
thanks in advance, Chuck