CURRENT_CONNECTION

`CURRENT_CONNECTION`

Unique identifier of the current connection.

Type

BIGINT

Syntax

CURRENT_CONNECTION

Its value is derived from a counter on the database header page, which is incremented for each new connection.When a database is restored, this counter is reset to zero.

Examples

select current_connection from rdb$database

execute procedure P_Login(current_connection)

`INSERTING`

Indicates if the trigger fired for an INSERT operation

Available in

PSQL — triggers only

Type

BOOLEAN

Syntax

INSERTING

Intended for use in multi-action triggers.

Example

if (inserting or updating) then
begin
  if (new.serial_num is null) then
    new.serial_num = gen_id(gen_serials, 1);
end