<< SQL language reference | Documentation | Firebird 2.1 language reference update >>
Firebird 2.5 Language Reference Update
Everything new in Firebird SQL since InterBase 6
Paul Vinkenoog et al.
12 June 2011, document version 1.0 — covers Firebird 2.5
...currently being updated.
| Introduction |
| New in Firebird 2.5 |
| Reserved words and keywords |
| Miscellaneous language elements |
| Data types and subtypes |
| DDL statements |
| DML statements? |
| Transaction control statements? |
| PSQL statements? |
| Security and access control? |
| Context variables? |
| Operators and predicates? |
| Aggregate functions? |
| Internal functions? |
- ABS()
- ACOS()
- ASCII_CHAR()
- ASCII_VAL()
- ASIN()
- ATAN()
- ATAN2()
- BIN_AND()
- BIN_OR()
- BIN_SHL()
- BIN_SHR()
- BIN_XOR()
- BIT_LENGTH()
- CAST()
- CEIL(), CEILING()
- CHAR_LENGTH(), CHARACTER_LENGTH()
- COALESCE()
- COS()
- COSH()
- COT()
- DATEADD()
- DATEDIFF()
- DECODE()
- EXP()
- EXTRACT()
- FLOOR()
- GEN_ID()
- GEN_UUID()
- HASH()
- IIF()
- LEFT()
- LN()
- LOG()
- LOG10()
- LOWER()
- LPAD()
- MAXVALUE()
- MINVALUE()
- MOD()
- NULLIF()
- OCTET_LENGTH()
- OVERLAY()
- PI()
- POSITION()
- POWER()
- RAND()
- RDB$GET_CONTEXT()
- RDB$SET_CONTEXT()
- REPLACE()
- REVERSE()
- RIGHT()
- ROUND()
- RPAD()
- SIGN()
- SIN()
- SINH()
- SQRT()
- SUBSTRING()
- TAN()
- TANH()
- TRIM()
- TRUNC()
- UPPER()
| External functions? |
- abs
- acos
- addDay
- addHour
- addMilliSecond
- addMinute
- addMonth
- addSecond
- addWeek
- addYear
- ascii_char
- ascii_val
- asin
- atan
- atan2
- bin_and
- bin_or
- bin_xor
- ceiling
- cos
- cosh
- cot
- dow
- dpower
- floor
- getExactTimestamp
- i64round
- i64truncate
- ln
- log
- log10
- lower
- lpad
- ltrim
- mod
- *nullif
- *nvl
- pi
- rand
- right
- round, i64round
- rpad
- rtrim
- sdow
- sign
- sin
- hsin
- sqrt
- srand
- sright
- string2blob
- strlen
- substr
- substrlen
- tan
- tanh
- truncate, i64truncate
| Appendix A: Notes? |
| Appendix B: Reserved words and keywords - full lists? |
| Appendix C: Document history? |
| Appendix D: License notice? |
back to top of page
<< SQL language reference | Documentation | Firebird 2.1 language reference update >>
License note
The contents of this Documentation are subject to the Public Documentation License Version 1.0 (the "License"); you may only use this Documentation if you comply with the terms of this License. Copies of the License are available here or at http://www.firebirdsql.org/pdfmanual/pdl.pdf (PDF) and http://www.firebirdsql.org/manual/pdl.html (HTML).
The Original Documentation is titled Firebird 2.1 Language Reference Update.
The Initial Writers of the Original Documentation are: Paul Vinkenoog et al.
Copyright (C) 2008-2010. All Rights Reserved. Initial Writers contact: paul at vinkenoog dot nl.
Writers and Editors of included PDL-licensed material (the "al.") are: J. Beesley, Helen Borrie, Arno Brinkman, Frank Ingermann, Vlad Khorsun, Alex Peshkov, Nickolay Samofatov, Adriano dos Santos Fernandes, Dmitry Yemanov.
Included portions are Copyright (C) 2001-2009 by their respective authors. All Rights Reserved.
