................... 299 INSERT .................................................................................................................................. 302 INSERT ... VALUES .............. ............................. 303 INSERT ... SELECT ....................................................................................................... 303 INSERT ... DEFAULT VALUES .............. ................................................................................. 309 UPDATE OR INSERT ................................................................................................

231 6.2. INSERT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235 6.2.1. INSERT … VALUES . . 236 6.2.2. INSERT … SELECT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 6.2.3. INSERT … DEFAULT VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245 6.4. UPDATE OR INSERT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

вместо типа данных TYPE OF COLUMN в объявлениях параметров и переменных EXECUTE PROCEDURE INSERT INSERT ... DEFAULT VALUES Предложение RETURNING Разрешено использовать UNION в операторе SELECT при BY PLAN Использование COLLATE для столбцов с текстовым BLOB RETURNING ROWS UPDATE OR INSERT 8. Управление транзакциями RELEASE SAVEPOINT ROLLBACK ROLLBACK RETAIN ROLLBACK TO SAVEPOINT 'date/timestring' Пример: UPDATE PEOPLE SET AGECAT = 'Old' WHERE BIRTHDATE < DATE '1-Jan-1943' INSERT INTO APPOINTMENTS (EMPLOYEE_ID, CLIENT_ID, APP_DATE, APP_TIME) VALUES (973, 8804, DATE 'today'

312 6.2. INSERT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 316 6.2.1. INSERT … VALUES . . 318 6.2.2. INSERT … SELECT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318 6.2.3. INSERT … DEFAULT VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327 6.4. UPDATE OR INSERT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 3.2.1. Creating a generator (“Insert”) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.4.1. Before Insert trigger, version 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.4.2. Before Insert trigger, version 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.4.3. Before Insert trigger, version 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

301 6.2. INSERT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305 6.2.1. INSERT … VALUES . . 307 6.2.2. INSERT … SELECT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 307 6.2.3. INSERT … DEFAULT VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 315 6.4. UPDATE OR INSERT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 3.2.1. Einen Generator erzeugen (“Insert”) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.4.1. Before Insert Trigger, Version 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.4.2. Before Insert Trigger, Version 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.4.3. Before Insert Trigger, Version 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 3.2.1. Создание генератора (“Insert”). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.4.1. Триггер Before Insert, версия 1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.4.2. Триггер Before Insert, версия 2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 4.4.3. Триггер Before Insert, версия 3. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

value is assigned to it. The same is true for output parameters in stored procedures. • If you insert a record into a table and you only provide values for part of the fields, the remaining fields will initialised to NULL except where a default value is in effect or a value is assigned by a “before insert” trigger. • If you add a column to a table that already has records, the fields added to the existing NULL is done with the ‘=’ operator, just like assigning values. You can also include NULL in an insert list or use it as input parameter to a stored procedure (both are special types of assignments)

VARCHAR(100)); SQL> COMMIT; SQL> INSERT INTO NORMAN VALUES ('Firebird'); SQL> INSERT INTO NORMAN VALUES ('Firebird Book'); SQL> INSERT INTO NORMAN VALUES ('666'); SQL> INSERT INTO NORMAN VALUES ('abcabcab ('abcabcabcabcabcabcabcabcd'); SQL> INSERT INTO NORMAN VALUES ('AaaaaBbbbbbbbbbCccccccccccccccDD'); SQL> COMMIT; SQL> INSERT INTO NORMAN VALUES (NULL); SQL> COMMIT; We now have a table and some data inserted by in the order we inserted them. Do not be misled — if I was to delete one or more records and then insert new ones, Firebird could reuse some or all of the newly deleted space, so record 1, for example