. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 3.1. Integer Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 3.1.2. INTEGER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.1.4. Hexadecimal Format for Integer Numbers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.1. Integer Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 3.1.2. INTEGER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 3.1.5. Hexadecimal Format for Integer Numbers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 3

dsql_transitional_numeric Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect %d does not 335544334 convert_error Conversion error from string "%s" -413 335544454 nofilter Filter not found to convert type %ld to type %ld -413 335544860 blob_convert_error Unsupported conversion to target type BLOB BLOB (subtype %d) -413 335544861 array_convert_error Unsupported conversion to target type ARRAY -501 335544327 bad_req_handle Invalid request handle -501 335544577 dsql_cursor_close_err Attempt to reclose

dsql_transitional_numeric Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect @1 does not 335544334 convert_error Conversion error from string "@1" -413 335544454 nofilter Filter not found to convert type @1 to type @2 -413 335544860 blob_convert_error Unsupported conversion to target type BLOB BLOB (subtype @1) -413 335544861 array_convert_error Unsupported conversion to target type ARRAY -501 335544577 dsql_cursor_close_err Attempt to reclose a closed cursor -502 336003090 dsql_cursor_redefined

dsql_transitional_numeric Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3 -104 336003077 sql_db_dialect_dtype_unsupport Database SQL dialect does out of bounds -407 335544435 nullsegkey Null segment of UNIQUE KEY -413 335544334 convert_error Conversion error from string "" -413 335544454 nofilter Filter not found to convert type include starting page number -598 335544633 dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not

............................................................................................ 30 INTEGER ................................................................................................ зависит от платформы FLOAT 32 бита 1,175 x 10-38 .. 3,402 x 1038 IEEE одинарной точности, 7 цифр INTEGER INT 32 бита –2 147 483 648 .. 2 147 483 647 signed long NUMERIC (precision, scale) Переменный календарь. Целочисленные типы данных Для целых чисел используют целочисленные типы данных SMALLINT, INTEGER и BIGINT (в 3 диалекте). Firebird не поддерживает беззнаковый целочисленный тип данных. SMALLINT

SUM(Salary) IS NOT NULL suppresses the sixth row (the one with Dept = 120). [1] If Field is of an integer type, AVG is always rounded towards 0. For instance, 6 non-null INT records with a sum of -11 yield and/or '' (for string arguments). 4. If the function performs an undesired NULL <=> non-NULL conversion, you’ll have to anticipate it in your code before calling the UDF (see also Testing for NULL — 5 and higher can convert NULL to most anything else. This enables you to perform an on-the-fly conversion and use the result in your further processing, without the need for “if (MyExpression is null)

not familiar with the concept of generators; • have questions on using them; • want to make an Integer column behave like an “AutoInc” field as found in other RDBMSs; • are looking for examples on how Chapter 2. Generator Basics 2.1. What is a generator? Think of a generator as a “thread-safe” integer counter that lives inside a Firebird database. You can create one by giving it a name: CREATE GENERATOR GENERATOR GenTest; Then you can get its current value and increase or decrease it just like a “var i:integer” in Delphi, but it is not always easy to “predictably” set it directly to a certain value and then

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 3.1.2. INTEGER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.1.4. Hexadezimales Format für Integer-Zahlen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3.2 von Uhrzeitdaten verfügbar. ◦ Der Datentyp DATE speichert nur Datumsinformationen. ◦ Der 64-Bit-Integer-Datentyp BIGINT ist verfügbar. ◦ Doppelte Anführungszeichen sind für die Abgrenzung nicht regulärer

2.1) In cases where an indexed field and an argument have different data types and the implicit conversion cannot be performed consistently, the index will be ignored. Prior versions that appeared to “work” STRING_FIELD = INTEGER_ARGUMENT. The indexed scan is for this predicate is now disallowed since a numeric can be converted to a string in different ways. However, for the reverse case, INTEGER_FIELD = STRING_ARGUMENT STRING_ARGUMENT, index scanning is allowed because the conversion is deterministic. (V.2.1) Some date/time expressions in Dialect 1 can not benefit from available indices either, e.g., DATE_ FIELD > 'NOW'