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

[Thiemo Kellner]

In the case that the task is to select all records from mytable where the full_address contains the string pao_text, the like clause is probably much more efficient:

select * from mytable where full_address like '%pao_text%';



Cheers

Thiemo

Quoting Bo Victor Thomsen <bo.victor.thom...@gmail.com>:

Performance might not be an issue here but it is never bad to have an eye on efficiency in my opinion.

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;

 S/MIME Public Key:
https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Threema (Safer than WhatsApp): A76MKH3J
Handys: +41 78 947 36 21 | +49 1578 772 37 37

smime.p7s
Description: S/MIME Signature

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users