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

[Bo Victor Thomsen]

select * from mytable where full_address ~* *'*pao_text*'*;
^               ^

You've forgotten the string delimiters

Med venlig hilsen / Kind regards

Bo Victor Thomsen

Den 17-12-2020 kl. 11:53 skrev Shaozhong SHI:
> select * from mytable where full_address ~* pao_text;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201217/b61cf589/attachment.html>