that are to be selected, updated or deleted. The ORDER BY clause specifies how the output data — result set — should be sorted. Options Options, being the simplest constructs, are specified in association digits. The reason is that precision was “sacrificed” to be able to store a smaller value. This is a result of how the value is stored: as a decimal value of 16 or 34 digits and an exponent. For example 1 full 38 digits. For complex calculations, those digits are cast internally to DECFLOAT(34). The result of various mathematical operations, such as LOG(), EXP() and so on, and aggregate functions using

that are to be selected, updated or deleted. The ORDER BY clause specifies how the output data — result set — should be sorted. Options Options, being the simplest constructs, are specified in association days. Table 5. Arithmetic Operations for Date and Time Data Types Operand 1 Operation Operand 2 Result DATE + TIME TIMESTAMP DATE + Numeric value n DATE increased by n whole days. Broken values are within the range DECIMAL(9, 4) Chapter 3. Data Types and Subtypes 31 Operand 1 Operation Operand 2 Result TIME - Numeric value n TIME reduced by n seconds. The fractional part is taken into account TIMESTAMP

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 5.2.1. Result values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . elements are purposely designed to give an unambiguous result with NULL (unambiguous in the sense that some specific action is taken and/or a non-NULL result is returned). They are discussed in the following test for nullness. This syntax is illegal in Firebird versions up to 1.5.n, and gives the wrong result in Firebird 2 and up: it returns NULL no matter what you compare. This is by design, incidentally

Использование альтернативных апострофов в строковых литералах -- result: abc{def}ghi SELECT Q'{abc{def}ghi}' FROM rdb$database; -- result: That's a string SELECT Q'!That's a string!' FROM rdb$database; else if ... else if. Простой CASE Синтаксис: CASE WHEN THEN <result> [WHEN THEN <result> ...] [ELSE ] END При использовании этого варианта используется в функции DECODE. Поисковый CASE Синтаксис: CASE WHEN THEN <result> [WHEN THEN <result> …] [ELSE ] END Здесь выражение,

else if ... else if”. Простой CASE Синтаксис: CASE WHEN THEN result [WHEN THEN result ...] [ELSE defaultresult] END При использовании этого варианта сравнивается RELIGION FROM PEOPLE Поисковый CASE Синтаксис: CASE WHEN THEN result [WHEN THEN result …] [ELSE defaultresult] END Здесь выражение, которое даёт тройной логический DECODE(, , result [,, result …] 255 Руководство по языку SQL [, defaultresult]) Эквивалентная конструкция CASE CASE WHEN THEN result [WHEN THEN result …] [ELSE defaultresult]

the employee database without credentials (and making sure no embedded connection is made) will result in this error message: SQL> connect xnet://employee; Statement failed, SQLSTATE = 28000 Missing of the backslash in the username. (Specifying just frank will be accepted by Firebird, but won’t result in a working mapping on most, if not all, Windows systems.) You can drop any mapping with the command: 1. Division of an integer by an integer Firebird accords with the SQL standard by truncating the result (quotient) of an integer/integer calculation to the next lower integer. This can have bizarre results

25 Division of an integer by an integer Firebird accords with the SQL standard by truncating the result (quotient) of an integer/integer calculation to the next lower integer. This can have bizarre results or both. For example, the calculation above could be modified thus in order to produce a non-zero result: 1.000 / 3 = 0.333 Things to know about strings String delimiter symbol Strings in Firebird are Start 26 Firebird will raise an error if the result of a string concatenation exceeds the maximum (var)char size of 32 Kb. If only the potential result – based on variable or field size – is too long

if”-Klauseln funktioniert. Einfaches CASE Syntax … CASE WHEN THEN <result> [WHEN THEN <result> ...] [ELSE ] END … Bei dieser Variante wird test-expr mit dem ersten DECODE -Funktion verwendet. Gesuchtes CASE Syntax CASE WHEN THEN <result> [WHEN THEN <result> …] [ELSE ] END Der bool_expr-Ausdruck gibt ein ternäres logisches jeweils eine oder mehrere columns oder fields enthalten. Die Summe der zurückgegebenen Zeilen ist der result set der Anweisung. Chapter 6. Data Manipulation-Statements (DML) 240 Die einzigen obligatorischen

divide a floating- point value by zero. -901 335544773 exception_float_inexact_result Floating-point inexact result. The result of a floating-point operation cannot be represented as a deciaml fraction. exception_float_stack_check Floating-point stack check. The stack overflowed or underflowed as the result of a floating-point operation. -901 335544777 exception_float_underflow Floating-point underflow -901 335544779 exception_integer_overflow Integer overflow. The result of an integer operation caused the most significant bit of the result to carry. -901 335544780 exception_unknown An exception occurred

divide a floating-point value by zero. -901 335544773 exception_float_inexact_result Floating-point inexact result.The result of a floating-point operation cannot be represented as a deciaml fraction. exception_float_stack_check Floating-point stack check.The stack overflowed or underflowed as the result of a floating-point operation. -901 335544777 exception_float_underflow Floating-point underflow -901 335544779 exception_integer_overflow Integer overflow.The result of an integer operation caused the most significant bit of the result to carry. -901 335544780 exception_unknown An exception occurred