Subject Re: [firebird-support] UDFs and Exceptions
Author Milan Babuskov
firebird@... wrote:
> It's pretty clear that UDFs can't provoke an SQL error, which is unfortunate
> for me, because I have a Regular Expression UDF and it would've been
> great if I could've returned an error in this way when the pattern had an
> error (as opposed to not matching).

You could return an integer:

0 - matches
1 - doesn't match
2 - error in pattern

Milan Babuskov