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
http://swoes.blogspot.com/
http://www.flamerobin.org