> > In PSQL is there a difference between these 2 statements:
> >
> > select CREATEGUID() from RDB$DATABASE into :USERID;
>
> Or you can use this as well:
>
> select CREATEGUID() from rdb$database left join rdb$relations on
> rdb$database.rdb$relation_id=rdb$relations.rdb$relation_id left join

rdb$procedures on

> rdb$relations.rdb$relation_id=rdb$procedures.rdb$procedure_id into

:USERID;

Hmmm... this looks overly complicated to me. Did you test it?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com