Dear Rob, Please do not go offlist. Its not a matter of cancelling, consider the fragment --> relname like 'coil\\_status' the underscore has to be escaped because if its not done '_' will match any *single* character (rule of ilike matching) , its escaped so that it matches '_' in strings. two backslash is required so that ilike gets \_ it is the rule of quoting literal values in sql. if you can add E you can get rid of the warnings. Regds Rajesh Kumar Mallah. On Tue, Oct 5, 2010 at 2:18 PM, Rob Richardson <Rob.Richardson@xxxxxxxxxxx> wrote: > Thank you very much! Your examples worked as you said they would work, and > they showed that my database is logging those warnings when they happen. > That indicates that the difference is in the Crystal Reports installation > someplace. > > I don't understand how the backslashes are handled. I added underscores to > a couple of records in my coilstatus table, so one had "Fr_ee" and another > had "Pack_ed". Then, the query "SELECT status from coilstatus where status > like '%\\_%' limit 10;" gave me the warning that you predicted, and it found > the two records with underscored statuses. That tells me that the two > backslashes cancelled each other out, and the query was the same as "SELECT > status from coilstatus where status like '%_%' limit 10;". Why is that? > Do I need to read about regular expressions? > > RobR > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
