Search code examples
firebirdfirebird2.5

A function that returns the High() of an Integer type

Is there a function in Firebird that returns the High() or Low() of the integer types (Integer, BigInt)?

An example may be...

SELECT HIGH(integer) FROM RDB$DATABASE

will result in

2147483647
Solution

  • No. The only way to get it is to write a custom UDF.