Subject Re[2]: [ib-support] Features and Comparisons to PostgreSQL
Author Daniel Rail
>> > > 14. Regular expression support
>> > Yes. You use the LIKE in your WHERE clause.
>> Wildcard masks with LIKE operator, but no regular expressions (yet).

> Couldn't be an UDF used for that?
> Something like
> select name from my_table where udf_regexp(name,"my_regular_expression")?

Yes you can, but just one thing is missing from your query.

select name from my_table
where udf_regexp(name,"my_regular_expression")=1

Your "udf_regexp" function would return 1 for found and 0 for not
found (or any other value of your choice). Probably(not sure though)
with the implementation of the BOOLEAN type it would be possible to
use the statement you wrote.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (