Subject Re: [ib-support] Idea for a new field type for FB 2,0 or IB 7?
Author Jason Wharton
> Also RETURNING should be independent of
> the actual inserted fields, so if you have a value calculated in a
> trigger you can return that value as part of the insert.

I agree entirely. That is why I suggested a syntax that allows you to put in
your own list of columns (or expressions) to be returned to the client. You
may only be interested in getting one or two columns and not all the columns
of the record. I also suggested the INTO clause for use in stored procedure
and trigger language. This allows us to have full advantage of trigger
altered values being surfaced without having to do a separate select after
the fact of performing some operation. Lots of code will tidy up very nicely
with such a capability.

Jason Wharton
CPS - Mesa AZ