FreeAdhocUDF for InterBase and FireBird in deutschin englishen françaisen españolin italianoa português
homeprevious pageÜbersicht • overview • aperçunext pagelast page Seite empfehlen • advice website •Forum mailing-listwas ich vermisse • what I missed •eMail Kommentar • eMail commentprintsitemap
 
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;
nach oben • go top •
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;
nach oben • go top •
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;
nach oben • go top •
 
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;
nach oben • go top •
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;
nach oben • go top •
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;
vorige Seite • previous page • passée sitenach oben • go top • vers le hautnächste Seite • next page • prochain site