for InterBase and FireBird

Functions enclosed in FreeAdhocUDF.dll/.so/.dylib :
Functions for constants		6 functions
	Numeric Constants	3 functions
	Physical Constants	3 functions
		since FireBird 2.1 this function is substitutable with a native SQL statement

 

Functions for constants: Numeric Constants
from		substitutable with PI
F_PI		function from adhoc input/output-compatibility to rFunc (PI)
Entrypoint	pi	compatible with UTF-8
Input	nothing
Output	DOUBLE	Circle Pi
TestSQL SELECT CAST(3.141592653589793 AS DOUBLE PRECISION) AS ISCORRECT, F_PI() FROM RDB$DATABASE;
F_E		function from adhoc input/output-compatibility to rFunc (E)
Entrypoint	euler	compatible with UTF-8
Input	nothing
Output	DOUBLE	Eulernumber e
TestSQL SELECT 2.718281828459045 AS ISCORRECT, F_E() FROM RDB$DATABASE;
F_EPSILON		function from adhoc
Entrypoint	euler	compatible with UTF-8
Input	nothing
Output	DOUBLE	number epsilon (as a very small number to check against epsilon instead of 0)
TestSQL SELECT CAST(2.2204460492503131e-14 AS DOUBLE PRECISION) AS ISCORRECT, F_EPSILON() FROM RDB$DATABASE;

 

Functions for constants: Physical Constants
F_C		function from adhoc
Entrypoint	c	compatible with UTF-8
Input	nothing
Output	INTEGER	constant c for speed of light [m/s]
Output with BY VALUE TestSQL SELECT 299792458 AS ISCORRECT, F_C() FROM RDB$DATABASE;
F_G		function from adhoc
Entrypoint	g	compatible with UTF-8
Input	nothing
Output	DOUBLE	constant g for acceleration of gravity [m/s^2]
Output with BY VALUE TestSQL SELECT CAST(9.80665 AS DOUBLE PRECISION) AS ISCORRECT, F_G() FROM RDB$DATABASE;
F_KELVIN		function from adhoc
Entrypoint	k	compatible with UTF-8
Input	nothing
Output	DOUBLE	constant for absolute zero = 0 degree Kelvin
Output with BY VALUE TestSQL SELECT -273.15 AS ISCORRECT, F_KELVIN() FROM RDB$DATABASE;