Subject Re: [Firebird-Architect] Re: Indexed Views
Author Dmitry Yemanov
"Jim Starkey" <jas@...> wrote:
> I built a scheme in blr (blr_store2) to handling this, but it maps very
> poorly into SQL. To be completely honest, it maps poorly into
> everything else, too.

Why? The RETURNING clause does this job perfectly. IIRC, this question was
raised (and partially discussed) in fb-devel. This is what Oracle offers:

PSQL: <statement> [RETURNING <values> INTO <variables>]
Client: <statement> [RETURNING <values>]

where <statement> is INSERT, UPDATE or DELETE.

And PSQL version of INSERT worked quite well (using blr_store2) in my
private tree 6 months ago. If people do want this, let's just agree on
syntax/semantics and I'll provide a patch for both Vulcan and HEAD in one