View Revisions: Issue #1571

Summary 0001571: Firebird 4.0 Beta features (1).
Revision 2019-11-21 11:02 by barry
Description - DECFLOAT datatype.
- TIMESTAMP WITH TIME ZONE.
Revision 2019-11-21 11:54 by barry
Description - DECFLOAT datatype.
- TIMESTAMP WITH TIME ZONE.
- SET DECFLOAT <property-name> [TO] <value>
Revision 2019-11-21 12:59 by barry
Description - DECFLOAT datatype.
- TIMESTAMP WITH TIME ZONE.
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n).
Revision 2019-11-21 14:34 by barry
Description - DECFLOAT datatype.
- TIMESTAMP WITH TIME ZONE.
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n).
- Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
Revision 2019-11-21 15:37 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
Revision 2019-11-21 15:40 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
- Функции: FIRST_DAY(...), LAST_DAY(...).
Revision 2019-11-21 15:55 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
Revision 2019-11-21 16:05 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
Revision 2019-11-21 16:09 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
- HASH(...) function.
Revision 2019-11-21 16:57 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT BIND <bind-type>
Revision 2019-11-21 17:05 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
Revision 2019-11-21 17:09 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
Revision 2019-11-21 17:31 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
Revision 2019-11-21 18:25 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ SET SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]

Revision 2019-11-21 18:32 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]

Revision 2019-11-21 18:45 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
Revision 2019-11-21 18:50 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
Revision 2019-11-21 19:12 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
Revision 2019-11-22 08:58 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()

- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 09:00 by barry
Description - DECFLOAT datatype (+script).
- TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)

- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 09:04 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)

- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 09:18 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- SET DECFLOAT <property-name> [TO] <value>
- BINARY(n), VARBINARY(n) (+script).
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()

- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 09:39 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()

- Extensions to the IDENTITY Type
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 09:41 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()

- Extensions to the IDENTITY Type
- DEFAULT Context Value for Inserting and Updating
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 09:51 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 09:57 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions

- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 10:14 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions
- AT Expression (Time Zone)
- LOCALTIME Expression (Factor)
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 10:15 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions
- AT Expression (Time Zone)
- LOCALTIME, LOCALTIMESTAMP Expression (Factor)
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 10:16 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION
+ LOCALTIME, LOCALTIMESTAMP Expression (Factor)

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions
- AT Expression (Time Zone)
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 10:21 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION
+ LOCALTIME, LOCALTIMESTAMP Expression (Factor)

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions
- AT Expression (Time Zone)
- Allow Management Statements in PSQL Blocks
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-22 11:03 by barry
Description - DECFLOAT datatype (+script).
- TIME, TIMESTAMP WITH TIME ZONE (+script).
- BINARY(n), VARBINARY(n) (+script).
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION
+ LOCALTIME, LOCALTIMESTAMP Expression (Factor)
+ Allow Management Statements in PSQL Blocks

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions
- AT Expression (Time Zone)
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-23 11:21 by barry
Description + DECFLOAT datatype
+ TIME, TIMESTAMP WITH TIME ZONE
+ BINARY(n), VARBINARY(n)
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION
+ LOCALTIME, LOCALTIMESTAMP Expression (Factor)
+ Allow Management Statements in PSQL Blocks

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions
- AT Expression (Time Zone)
- (?) HEX-string: x'0154090759DF'
Revision 2019-11-23 11:22 by barry
Description + DECFLOAT datatype
+ TIME, TIMESTAMP WITH TIME ZONE
+ BINARY(n), VARBINARY(n)
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION
+ LOCALTIME, LOCALTIMESTAMP Expression (Factor)
+ Allow Management Statements in PSQL Blocks

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions
- AT Expression (Time Zone)
- HEX-string: x'0154090759DF' (from FB v.2.5: https://firebirdsql.org/refdocs/langrefupd25-hexbinstrings.html)
Revision 2019-11-23 11:26 by barry
Description + DECFLOAT datatype
+ TIME, TIMESTAMP WITH TIME ZONE
+ BINARY(n), VARBINARY(n)
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION
+ LOCALTIME, LOCALTIMESTAMP Expression (Factor)
+ Allow Management Statements in PSQL Blocks

+ HEX-string: x'0154090759DF' (from FB v.2.5: https://firebirdsql.org/refdocs/langrefupd25-hexbinstrings.html)

- Extensions to the IDENTITY Type
- OVERRIDING Clause for IDENTITY Columns
- Extension of SQL Windowing Features
- FILTER Clause for Aggregate Functions
- AT Expression (Time Zone)
Revision 2019-11-25 09:53 by barry
Description + DECFLOAT datatype
+ TIME, TIMESTAMP WITH TIME ZONE
+ BINARY(n), VARBINARY(n)
+ SET DECFLOAT <property-name> [TO] <value>
+ Функции (для DECFLOAT): COMPARE_DECFLOAT, NORMALIZE_DECFLOAT, QUANTIZE, TOTALORDER.
+ Функции: FIRST_DAY(...), LAST_DAY(...).
+ TIMEZONE_HOUR, TIMEZONE_MINUTE в функции EXTRACT(...).
+ HASH(...) function.
+ SET TIME ZONE { <time zone string> | LOCAL }
+ SET DECFLOAT ROUND <mode>
+ SET DECFLOAT TRAPS TO <traps list>
+ SET DECFLOAT BIND <bind-type>
+ SET INT128 BIND <bind-type>
+ RETURNING * Now Supported
+ ALTER SESSION RESET
+ SET SESSION IDLE TIMEOUT <value> [HOUR | MINUTE | SECOND]
+ SET STATEMENT TIMEOUT <value> [HOUR | MINUTE | SECOND | MILLISECOND]
+ SET LOCAL_TIMEOUT <int>
+ ENCRYPT() and DECRYPT()
+ RSA_ENCRYPT(...), RSA_DECRYPT(...)
+ RSA_SIGN(), RSA_VERIFY()
+ DEFAULT Context Value for Inserting and Updating
+ Optional AUTOCOMMIT for SET TRANSACTION
+ LOCALTIME, LOCALTIMESTAMP Expression (Factor)
+ Allow Management Statements in PSQL Blocks

+ HEX-string: x'0154090759DF' (from FB v.2.5: https://firebirdsql.org/refdocs/langrefupd25-hexbinstrings.html)