EXTERNAL FUNCTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159 5.9.1. DECLARE EXTERNAL FUNCTION . . . . . 5.9.2. ALTER EXTERNAL FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 5.9.3. DROP EXTERNAL FUNCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 248 6.5.1. Aliases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

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 . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 8.1.3. Using Database Aliases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 19.9. SHOW FUNCtions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . prompting. ◦ Add and modify data. ◦ Grant user permissions. ◦ Perform database administrative functions. • Directly from the command line, with individual options and without starting an interactive

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

executable. • One or more client libraries. • The command-line tools. • The standard user-defined function libraries. • A sample database. • The C header files (not needed by beginners). • Release notes etc. \bin Sample database employee.fdb \examples\ empbuild User-defined function (UDF) li- braries ib_udf.dll, fbudf.dll \UDF Additional server-side libraries icu* only terminates the first process (the listener). Other processes, if present, will continue to function normally, each terminating when the client disconnects from the database. Of course, once the listener

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) clause) -104 335544826 dsql_agg_nested_err Nested aggregate functions are not allowed -104 336003075 dsql_transitional_numeric Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled

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 part of the GROUP BY clause) -104 335544826 dsql_agg_nested_err Nested aggregate functions are not allowed -104 335544849 malformed_string Malformed string -104 335544851 command_end_err2 Unexpected

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) -104 335544826 dsql_agg_nested_err Nested aggregate functions are not allowed -104 335544849 malformed_string Malformed string -104 335544851 command_end_err2 Unexpected end of command- line @1, column

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 . . . . . . .

only terminates the first process (the listener). Other processes, if present, will continue to function Chapter 3. Installing Firebird 12 normally, each terminating when the client disconnects from information about the various parameters. Use database aliases Database aliases hide physical database locations from the client. Using aliases, a client can — for example — connect to “frodo:zappa” ic/underground/mothers_of_invention.fdb. Aliases also allow you to relocate databases while the clients keep using their existing connection strings. Aliases are listed in the file databases.conf, in