"rlee0001" <[EMAIL PROTECTED]> writes:
> My problem is with SUBSTRING. When it fails to find a match for the
> regexp pattern within the source string it returns NULL. Why?!
Because the SQL standard says so.
Of course, you're free to wrap the built-in function in your own
function that has behavior you like better for this case...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
