Alan McDonald wrote:

> Jon,
> you can't use this syntax in MySQL...!
> you have to ask for the LAST_INSERT_ID() which is connection specific,
> non-table specific.
> I think you would find the IB/FB generator construct a lot more flexible
>
> Alan

Sorry, to clarify I meant a SELECT in the form of
SELECT <function> as in SELECT LAST_INSERT_ID() which
makes intuitive sense to me as opposed to Firebird's:

select gen_id(GENNAME, 0) as GenVal from RDB$Database

which I can't figure out how it works because
gen_id(GENNAME,n) does not return a value by itself,
nor does there seem to be any entries in RDB$Database
if one does a 'select * from RDB$Database'.