Firebird
Páginas: 111 (27585 palabras)
Publicado: 18 de enero de 2013
Firebird 2.0 Language Reference Update
Everything new in Firebird SQL since InterBase 6
Paul Vinkenoog et al.
9 December 2010, document version 1.0 — covers Firebird 2.0–2.0.6
Firebird 2.0 Language Reference Update
Everything new in Firebird SQL since InterBase 6
9 December 2010, document version 1.0 — covers Firebird 2.0–2.0.6
Paul Vinkenoog et al.
Table of Contents
1.Introduction ....................................................................................................................................... 1
Versions covered ............................................................................................................................ 1
Authorship..................................................................................................................................... 2
2. Reserved words and keywords ............................................................................................................ 3
Added since InterBase 6 ................................................................................................................. 3
Newly reserved words............................................................................................................ 3
New keywords ....................................................................................................................... 4
Dropped since InterBase 6 .............................................................................................................. 4
No longer reserved................................................................................................................. 4
No longer keywords ............................................................................................................... 5
Possibly reserved in future versions ................................................................................................ 5
3. Miscellaneous language elements........................................................................................................ 6
-- (single-line comment) ................................................................................................................. 6
Shorthand casts .............................................................................................................................. 6CASE construct .............................................................................................................................. 7
Simple CASE ......................................................................................................................... 7
Searched CASE...................................................................................................................... 8
4. Data types and subtypes ..................................................................................................................... 9
BIGINT data type ........................................................................................................................... 9
BLOB data type.............................................................................................................................. 9
New character sets ....................................................................................................................... 10
Character set NONE handling changed ........................................................................................... 11
New collations............................................................................................................................. 12
5. DDL statements ............................................................................................................................... 13
ALTER DATABASE ...................................................................................................................... 13
BEGIN BACKUP...
Everything new in Firebird SQL since InterBase 6
Paul Vinkenoog et al.
9 December 2010, document version 1.0 — covers Firebird 2.0–2.0.6
Firebird 2.0 Language Reference Update
Everything new in Firebird SQL since InterBase 6
9 December 2010, document version 1.0 — covers Firebird 2.0–2.0.6
Paul Vinkenoog et al.
Table of Contents
1.Introduction ....................................................................................................................................... 1
Versions covered ............................................................................................................................ 1
Authorship..................................................................................................................................... 2
2. Reserved words and keywords ............................................................................................................ 3
Added since InterBase 6 ................................................................................................................. 3
Newly reserved words............................................................................................................ 3
New keywords ....................................................................................................................... 4
Dropped since InterBase 6 .............................................................................................................. 4
No longer reserved................................................................................................................. 4
No longer keywords ............................................................................................................... 5
Possibly reserved in future versions ................................................................................................ 5
3. Miscellaneous language elements........................................................................................................ 6
-- (single-line comment) ................................................................................................................. 6
Shorthand casts .............................................................................................................................. 6CASE construct .............................................................................................................................. 7
Simple CASE ......................................................................................................................... 7
Searched CASE...................................................................................................................... 8
4. Data types and subtypes ..................................................................................................................... 9
BIGINT data type ........................................................................................................................... 9
BLOB data type.............................................................................................................................. 9
New character sets ....................................................................................................................... 10
Character set NONE handling changed ........................................................................................... 11
New collations............................................................................................................................. 12
5. DDL statements ............................................................................................................................... 13
ALTER DATABASE ...................................................................................................................... 13
BEGIN BACKUP...
Leer documento completo
Regístrate para leer el documento completo.