Firebird 2.5 Language Reference Update
<< | Documentation | >>
Firebird 2.5 Language Reference Update
Everything new in Firebird SQL since InterBase 6
Paul Vinkenoog et al.
8th Oct 2011 version 1.1 — covers Firebird 2.5 and 2.5.1
| 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 |
- BEGIN ... BLOCKS may be empty
- BREAK
- CLOSE cursor
- DECLARE
- EXCEPTION
- EXECUTE PROCEDURE
- EXECUTE STATEMENT
- EXIT
- FETCH cursor
- FOR EXECUTE STATEMENT ... DO
- FOR SELECT INTO ... DO
- IN AUTONOMOUS TRANSACTION
- LEAVE
- OPEN cursor
- PLAN allowed in trigger code
- Subqueries as PSQL expressions
- UDFs callable as void functions
- WHERE CURRENT OF valid again for view cursors
| 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()
- CHAR_TO_UUID()
- 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()
- UUID_TO_CHAR()
| 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
- sinh
- 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
<< | Documentation | >>
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 https://www.firebirdsql.org/pdfmanual/pdl.pdf (PDF) and https://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.
