[postgis-users] ERROR: invalid regular expression: parentheses () not balanced

Shaozhong SHI shishaozhong at gmail.com
Thu Dec 17 02:53:59 PST 2020

I am doing the following:

select * from mytable where full_address ~* pao_text;

I keep getting this error.

But, I do the same thing with other columns and found no problem.

I wonder what else could cause this problem.

Can anyone enlighten me?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201217/47798f02/attachment.html>

More information about the postgis-users mailing list