|Subject||Re: [ib-support] Idea for a new field type for FB 2,0 or IB 7?|
> Also RETURNING should be independent ofI agree entirely. That is why I suggested a syntax that allows you to put in
> the actual inserted fields, so if you have a value calculated in a
> trigger you can return that value as part of the insert.
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.
CPS - Mesa AZ