Siva,
in addition to what others said, please note that underscore matches any
character. to change it use escape char.
http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-LIKE
2011/9/28 Siva Palanisamy
> Hi All,
>
> ** **
>
> I am trying to retrieve the contact
On Wed, 2011-09-28 at 12:33 +0530, Siva Palanisamy wrote:
> Hi All,
>
>
>
> I am trying to retrieve the contact names based on the keyed search
> string. It performs good for the English alphabets and behaves
> strangely for special chars such as _,/,\,%
>
>
The % character is used by SQL
Hi All,
I am trying to retrieve the contact names based on the keyed search string. It
performs good for the English alphabets and behaves strangely for special chars
such as _,/,\,%
My query in the function is similar to
SELECT contact_name FROM contacts WHERE LOWER(contact_name) LIKE
LOWER(
Hi All,
I am trying to retrieve the contact names based on the keyed search string. It
performs good for the English alphabets and behaves strangely for special chars
such as _,/,\,%
My query in the function is similar to
SELECT contact_name FROM contacts WHERE LOWER(contact_name) LIKE
LOWER(
