Hi, Single quote is for string not number. Why you need it? For external function it is converted from string to number.
If you declare external function you are limited to 2 arguments internal function have not this limitation. And i always prefere internal then external. Gbak have no problems but without knowing what are "others" i can not say anythink more. Regards, Karol Bieniaszewski ----- Reply message ----- Od: "Keisuke Kumakura" <[email protected]> Do: <[email protected]> Temat: [firebird-support] bin_and() in Firebird 2.5.2 Data: wt., paź 29, 2013 01:34 Hello, The SQL statement: select some from foo where bin_and(bar, '2')<>0; results in the error: Arguments for BIN_AND must be integral types or NUMERIC/DECIMAL without scale But if we omit single quote around 2(i.e., bin_and(bar, 2)<>0), the statement is executed fine. If we declare the following function, the statement is executed fine irrespective of bin_and(bar, '2') or bin_and(bar, 2). DECLARE EXTERNAL FUNCTION bin_and INTEGER, INTEGER RETURNS INTEGER BY VALUE ENTRY_POINT 'IB_UDF_bin_and' MODULE_NAME 'ib_udf'; a. Is it illegal to single-quote numeric(e.g., '2') ? b. Does overriding internal bin_and, bin_or functions pose any problems for firebird utilities like gbak, nbackup and others ? regards, K. Kumakura
