CONDITIONAL CONTAINING CSTRING DATABASE DESC DESCENDING DESCRIPTOR DO DOMAIN ENTRY_POINT EXCEPTION EXIT FILE FREE_IT GEN_ID GENERATOR IF INACTIVE INPUT_TYPE ISOLATION KEY LENGTH LEVEL MANUAL MODULE_NAME NAMES OPTION значение из нескольких возможных. Есть два синтаксических варианта: • Простой CASE, сравнимый с Pascal case или C switch; • Поисковый CASE, который работает как серия операторов “if ... else if ... else [ [, ...]] RETURNS { | PARAMETER 1-based_pos} [FREE_IT] ENTRY_POINT 'function_name' MODULE_NAME 'library_name' ::= sqltype [BY DESCRIPTOR]

которое позволяет вам внедрять SQL конструкции в ваш непосредственный язык программирования (C, C++, Pascal, Cobol и так далее) и производить обработку этих внедрённых конструкций в правильные вызовы Firebird значение из нескольких возможных. Есть два синтаксических варианта: • Простой CASE, сравнимый с Pascal case или C switch; • Поисковый CASE, который работает как серия операторов if ... else if ... else ]] RETURNS { sqltype [BY {DESCRIPTOR | VALUE}] | CSTRING(length) | PARAMETER param_num } [FREE_IT] ENTRY_POINT 'entry_point' MODULE_NAME 'library_name'; ::= sqltype [{BY DESCRIPTOR}

оператора CASE. Оператор CASE используется аналогично оператору switch языка C или оператору case языка Pascal для замены одного значения на другое. Обычно в СУБД Firebird 1.0 эту операцию можно эмулировать хранимой правильность с помощью isql или других утилит. Enterprise Manager IBOConsole Enterprise Manager IBExpert (free/commercial) Enterprise Manager DataBase Workbench (commercial) Import and Export Data - Performance

left-hand side expression is NULL than to evaluate each and every comparison result. But do feel free to skip them, or to skip just the second. Do not, however, skip the first question and start with when then ... [else ] end This one works more or less like a Pascal case or a C switch construct: is compared to , etc., until a match is question, e.g. like this: declare external function ltrim cstring(255) null returns cstring(255) free_it entry_point 'IB_UDF_ltrim' module_name 'ib_udf'; This requirement ensures that existing databases

application which allows you to embed SQL constructs into your host programming language (C, C++, Pascal, Cobol, etc.) and preprocess those embedded constructs into the proper Firebird API calls.  Only ones. Two syntactic variants are supported: • The simple CASE, comparable to a case construct in Pascal or a switch in C • The searched CASE, which works like a series of “if … else if … else if” clauses experience with regular expressions (or with highly formal, rather long top-down definitions). Feel free to skip it and read the next section, Building Regular Expressions, which uses a bottom-up approach

....................................................................................254 16.4.3.2. Free Space Map..................................................................................255 16 And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic. 2. A Brief History of PostgreSQL you won’t need to roll back to a particular savepoint again, it can be released, so the system can free some resources. Keep in mind that either releasing or rolling back to a savepoint will automatically

....................................................................................241 16.4.3.2. Free Space Map...........................................................................242 16.4.3.3. And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic. 2. A Brief History of PostgreSQL you won’t need to roll back to a particular savepoint again, it can be released, so the system can free some resources. Keep in mind that either releasing or rolling back to a savepoint will automatically

......................................................................................287 17.4.2. Free Space Map........................................................................................ And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic. 2. A Brief History of PostgreSQL you won’t need to roll back to a particular savepoint again, it can be released, so the system can free some resources. Keep in mind that either releasing or rolling back to a savepoint will automatically

......................................................................................288 17.4.2. Free Space Map........................................................................................ And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic. 2. A Brief History of PostgreSQL you won’t need to roll back to a particular savepoint again, it can be released, so the system can free some resources. Keep in mind that either releasing or rolling back to a savepoint will automatically

application which allows you to embed SQL constructs into your host programming language (C, C++, Pascal, Cobol, etc.) and preprocess those embedded constructs into the proper Firebird API calls.  Only values. Two syntactic variants are supported: • The simple CASE, comparable to a case construct in Pascal or a switch in C • The searched CASE, which works like a series of “if … else if … else if” clauses experience with regular expressions (or with highly formal, rather long top-down definitions). Feel free to skip it and read the next section, Building Regular Expressions, which uses a bottom-up approach