"Dimitry Sibiryakov" <aafemt@...> wrote:

>
> Not sure about before connect, but OLD and NEW contexts could be
> useful if they include connection params.
> Consider these examples:
>
> IF(OLD.ROLE = 'NONE') THEN
> NEW.ROLE = 'SIMPLE_USER';
>
> SELECT RDB$CHARSET FROM RDB$DATABASE INTO :NEW.CHARSET;

I really don't think this is a good idea. If you want to change the session
params via SQL, let's rather implement SET SESSION CHARACTERISTICS from
SQL2003.


Dmitry