5.9. FUNCTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 198 5.9.1. CREATE FUNCTION . . . 9.2. ALTER FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 205 5.9.3. CREATE OR ALTER FUNCTION . . . . . 5.9.4. DROP FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207 5.9.5. RECREATE FUNCTION . . . . . . .

................. 182 FUNCTION ............................................................................................................................. 182 CREATE FUNCTION ...................... .................................................................................... 188 ALTER FUNCTION ............................................................................................... .......................................................................... 191 CREATE OR ALTER FUNCTION ................................................................................. 191 Примеры

EXCEPTION CREATE OR ALTER EXCEPTION RECREATE EXCEPTION EXTERNAL FUNCTION DECLARE EXTERNAL FUNCTION ALTER EXTERNAL FUNCTION FILTER DECLARE FILTER INDEX CREATE INDEX PROCEDURE CREATE DATABASE и DROP DATABASE находится в разделе DATABASE; DECLARE EXTERNAL FUNCTION и ALTER EXTERNAL FUNCTION в EXTERNAL FUNCTION и т.д. CHARACTER SET ALTER CHARACTER SET Доступно: DSQL Добавлено: procname.paramname ::= CHARACTER SET | COLLATION | DOMAIN | EXCEPTION | EXTERNAL FUNCTION | FILTER | GENERATOR | INDEX | PROCEDURE | ROLE | SEQUENCE | TABLE | TRIGGER | VIEW Замечание

EXTERNAL FUNCTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159 5.9.1. DECLARE EXTERNAL FUNCTION . . . . . 5.9.2. ALTER EXTERNAL FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 5.9.3. DROP EXTERNAL FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 483 RDB$FUNCTION_ARGUMENTS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

5.9. FUNCTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 5.9.1. CREATE FUNCTION . . . 9.2. ALTER FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191 5.9.3. CREATE OR ALTER FUNCTION . . . . . 5.9.4. DROP FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193 5.9.5. RECREATE FUNCTION . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 14.1.1. The COALESCE function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 14.2.1. Firebird 1.5 and up: the NULLIF function. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 14.2.2 all that knowledge in a table for your easy reference: Table 7. Aggregate function results with different column states Function Results Empty set All-NULL set or column Other sets or columns COUNT(*)

Cannot use an aggregate function in a WHERE clause, use HAVING instead Firebird 1.5 Error Codes Updated 04/30/04 p. 3 -104 335544823 dsql_agg_group_err Cannot use an aggregate function in a GROUP BY clause contained in either an aggregate function or the GROUP BY clause) -104 335544825 dsql_agg_having_err Invalid expression in the (neither an aggregate function nor a part of the GROUP BY clause) more than 10 parameters Firebird 1.5 Error Codes Updated 04/30/04 p. 4 -171 335544439 funmismat Function could not be matched -171 335544458 invalid_dimension Column not array or invalid dimensions

dsql_agg_where_err Cannot use an aggregate function in a WHERE clause, use HAVING instead -104 335544823 dsql_agg_group_err Cannot use an aggregate function in a GROUP BY clause -104 335544824 dsql_agg_column_err aggregate function or the GROUP BY clause) Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -104 335544825 dsql_agg_having_err Invalid expression in the %s (neither an aggregate function nor a part 335544850 prc_out_param_mismatch Output parameter mismatch for procedure %s -171 335544439 funmismat Function %s could not be matched -171 335544458 invalid_dimension Column not array or invalid dimensions

dsql_agg_where_err Cannot use an aggregate function in a WHERE clause, use HAVING instead -104 335544823 dsql_agg_group_err Cannot use an aggregate function in a GROUP BY clause -104 335544824 dsql_agg_column_err (not contained in either an aggregate function or the GROUP BY clause) -104 335544825 dsql_agg_having_err Invalid expression in the @1 (neither an aggregate function nor a part of the GROUP BY clause) 335544850 prc_out_param_mismatch Output parameter mismatch for procedure @1 -171 335544439 funmismat Function @1 could not be matched -171 335544458 invalid_dimension Column not array or invalid dimensions

display system information