Hi David

I suppose pao_text needs to contain valid regular expression as value in every records of the table. You might want to inspect all those records containing at least one ( or ). If pao_text is not a column of the table, well you need to inspect its content, what ever it exactly is.

Hope that helps

Thiemo

Quoting Shaozhong SHI <shishaozh...@gmail.com>:

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?
    
   Regards,
    
   David
 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

Attachment: smime.p7s
Description: S/MIME Signature

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

Reply via email to