. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349 7.3. Stored Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Built-in Scalar Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 410 8.1. Context Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 414 8.2. Mathematical Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

15 CHAR_LENGTH, CHARACTER_LENGTH ............................................................ 426 HASH ................................................................................................. ..................................................................................... 664 RDB$FUNCTIONS ............................................................................................... | | | | <hash-item> ::= SORT () ::= JOIN (, [,

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264 7.3. Stored Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Built-in Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 8.1. Context Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311 8.2. Mathematical Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 421 8.3.5. HASH(). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 449 8.7. UUID Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 650 RDB$FUNCTIONS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

COT() DATEADD() DATEDIFF() DECODE() EXP() EXTRACT() MILLISECOND WEEK FLOOR() GEN_ID() GEN_UUID() HASH() IIF() LEFT() LN() LOG() LOG10() LOWER() LPAD() MAXVALUE() MINVALUE() MOD() NULLIF() OCTET_LENGTH() Операторы и предикаты (утверждения); • Агрегатные функции; • Встроенные функции; • UDF (User Defined Functions — функции, определённые пользователем. Также известные как внешние функции). Полная документация DATA DATEADD DATEDIFF DECODE DELETING DIFFERENCE EXP FIRST FIRSTNAME FLOOR GEN_UUID GENERATED GRANTED HASH IIF INSERTING LAST LASTNAME LEAVE LIST LN LOCK LOG LOG10 LPAD MAPPING MATCHED MATCHING MAXVALUE MIDDLENAME

(which is probably commented out) is: #Providers = Remote,Engine13,Loopback Now, either remove the hash mark and the Engine13 provider (this is the one that makes the embedded connections), or — better explicit — authentication. To work with objects inside the database, such as tables, views and functions, you (i.e. the Firebird user you’re logged in as) need explicit permissions on those objects, unless Firebird versions. What happened to gbak -r? It is now short for gbak -recreate_database, which functions the same as gbak -c[reate] and throws an error if the specified database already exists. You can

11 4. Internal functions and directives. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 4.1. Internal functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 8. Aggregate functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 13. User-Defined Functions (UDFs). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 In a non-interactive session, the user employs a shell script or batch file to perform database functions.  Because other applications in the Linux environment, for example, MySQL, also use isql as

Since Firebird 2.1, Windows domain administrators have had full access to the user management functions. This meant that when an admin user connected to the server and then used gsec, they had the ability cause all Windows Administrator accounts to automatically have full access to the user management functions. The automatic mapping can be revoked as follows: SQL> SQL> alter role rdb$admin drop auto admin Since Firebird 2.1, Windows domain administrators have had full access to the user management functions. This meant that when an admin user connected to the server and then used gsec, they had the ability

function nor a part of the GROUP BY 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 335544512 prcmismat Parameter mismatch for procedure -170 335544619 extern_func_err External functions cannot have more than 10 parameters Firebird 1.5 Error Codes Updated 04/30/04 p. 4 -171 335544439 extern_func_dir_error Function is in , which is not in a permitted directory for external functions. -902 335544819 io_32bit_exceeded_err File exceeded maximum size of 2GB. Add another database file