Hi,

> In PSQL is there a difference between these 2 statements:
>
> select CREATEGUID() from RDB$DATABASE into :USERID;

This one takes longer to write.

> -and-
>
> USERID = CREATEGUID();
>
> Or is it just a coding style/preference decision?

I prefer the latter, it's "more clear" in my book.

Besides, what are you going to do if someone revoked rights
from RDB$DATABASE :-)

With regards,

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