Bitwise operator in firebird

Question

Can we do bitwise and in a firebird procedure without using a UDF? is there one of the built in function or is there a way to get the same results with standard built in commands?

I tried http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-bin_and.html (BIN_AND) also but i need some implementation without UDF.

Ex: (3 & 3) returns 3 in SQL but not in firebird(firebird 2.1).

score 8 · Accepted Answer · edited Mar 17 '18 at 12:19

8

Firebird doesn't have bitwise operators, the BIN_AND() function is the way to go. Since Firebird 2.1 those BIN_* functions are internal functions, ie they are always available without need to any external DLL or registering them as UDF.

edited Mar 17 '18 at 12:19

Mark Rotteveel

100,966
191
140
197

answered Sep 13 '11 at 14:17

ain

22,394
3
54
74

Thanks, i was registering them as an UDF which i don't want to. – Rohit Vats Sep 13 '11 at 16:39
@RV1987 It is not clear from your comment if you understood ain's answer that they are internal functions and you don't need to declare them as UDF since Firebird 2.1 – Mark Rotteveel Sep 15 '11 at 08:22

Bitwise operator in firebird

1 Answers1