User Defined Function Libraries

Firebird has traditionally been weak in built in functions, with a very small set of standard functions. These have been augmented by a set of "standard" user defined functions which ship with the software as standard. However, as these are not available by default to the databases until a SQL script is run then you can never be sure they are available.

Firebird 2.1 changes this situation. This release introduced a standard set of built in functions, available to every database, without the need for SQL scripts. This set of functions supercedes the standard UDFs that shipped with previous versions of the database server.

Since I've been using firebird now since version 1, I have two primary libraries which I have used in the past. These have been mainly to do with blob manipulation and GUID creation.

It is likley that these libraries are not needed in firebird 2.1 or later. 

Last updated: 12 Mar 2008 20:15:56