meta data for this page
  •  

UDFs callable as void functions

Changed in: 2.0

Description

In Firebird 2.0 and above, PSQL code may call UDFs without assigning the result value, i.e. like a Pascal procedure or C void function. In most cases this is senseless, because the main purpose of almost every UDF is to produce the result value. Some functions however perform a specific task, and if you're not interested in the result value you can now spare yourself the trouble of assigning it to a dummy variable.

Note: RDB$GET_CONTEXT and RDB$SET_CONTEXT, though classified in this guide under internal functions, are actually a kind of auto-declared UDFs. You may therefore call them without catching the result. Of course this only makes sense for RDB$SET_CONTEXT.