> Can anyone tell me if there is some setting that will stop these warnings
> from showing up (other than turning off warning messages completely, which I
> am about to suggest that the customer do)? Also, does anyone know why my
> computer is not showing warnings while our customer's system is?
>
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.
t
Dear Rob ,
this will give warning:
SELECT co_name from foo where co_name ilike '%\\_%' limit 10;
and this will not:
SELECT co_name from foo where co_name ilike E'%\\_%' limit 10;
regds
Rajesh Kumar Mallah.
