|Subject||Re: [ib-support] Features and Comparisons to PostgreSQL|
>> > > 14. Regular expression supportYes you can, but just one thing is missing from your query.
>> > 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")?
select name from my_table
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.
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)