Language Reference has been accumulating in the tribal lore of the open source community of Firebird core developers and user-developers for 15 years. The gift of the InterBase 6 open source codebase in part of the SQL specifications. Originally, PSQL extensions were available in persistent stored modules (procedures and triggers) only, but in more recent releases they were surfaced in Dynamic SQL as see Expressions. 2.6. Comments Comments may be present in SQL scripts, SQL statements and PSQL modules. A comment can be any text specified by the code writer, usually used to document how particular

part of the SQL specifications. Originally, PSQL extensions were available in persistent stored modules (procedures and triggers) only, but in more recent releases they were surfaced in Dynamic SQL as see Expressions. 2.6. Comments Comments may be present in SQL scripts, SQL statements and PSQL modules. A comment can be any text specified by the code writer, usually used to document how particular executed, if no value is specified for it in the DML statement. Local variables and arguments in PSQL modules that reference this domain will be initialized with the default value. For the default value, use

Defined Functions) sont des fonctions qui ne sont pas internes au moteur, mais définies dans des modules séparés. Firebird est livré avec deux bibliothèques UDF : ib_udf (héritée d' InterBase) et fbudf

Moment den Wert vor dem ersten generierten Wert angibt. Dies wird in Firebird 4 behoben, siehe auch CORE-6376. Regeln • Der Datentyp einer Identitätsspalte muss ein exakter Zahlentyp mit Nullskala sein START WITH 0, während es START WITH 1 entsprechen sollte. Dies wird in Firebird 4 behoben, siehe auch CORE-6084  Nicht standardmäßiges Verhalten bei negativen Inkrementen Der SQL-Standard legt fest, dass dem im SQL-Standard angegebenen Verhalten. Dieser Fehler wird in Firebird 4 behoben, siehe auch CORE-6386  Eine falsche Verwendung der ALTER SEQUENCE-Anweisung (Änderung des aktuellen Werts der Sequenz

application is attempting to commit. Exceptions can be interleaved, and shared among the different modules of an application, and even among different applications sharing a database. They provide a simple

(User-Defined Functions) are functions that are not internal to the engine, but defined in separate modules. Firebird ships with two UDF libraries: ib_udf (a widely used “InterBase library”) and fbudf. You

ability to encrypt metadata, selected user data, or even the entire database. Not being a Firebird core developer, I cannot say categorically that it will not happen. However, the issue is not really whether

переменная ROW_COUNT возвращает значение 1, даже если было модифицировано или вставлено более 1 записи. См. CORE-4400. Предупреждение Если условие WHEN MATCHED присутствует, и несколько записей совпадают с записями относится также и к оператору выполнения хранимой процедуры EXECUTE PROCEDURE. Подробнее смотри в CORE-4483. Область действия оператора WHEN ... DO Оператор перехватывает ошибки и исключения в текущем всех строк в разбиении. В настоящее время предложение рамки окна (кадрирования) не реализовано см. CORE-3647. Пример 7.72. Навигационные функции SELECT id, salary, FIRST_VALUE(salary) OVER (ORDER

were done for V.2.1.2 in the way some of the Firebird binaries are built. (See also Tracker entry CORE-2243). These are the changes that enable Firebird Embedded to work even if the application structure