DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=VedgYHUeAmp3sF/xL2l8kSWlFwZLd79wk+ipTUJr4lsJSMezEJ0CXQAas7Be/CBeBQ
	SYLia0uwe2/KmJ6iDdgFaJtF3UyjPMJzAsTz7KzJ9lD/D3zbPFFQcwOxc58syQ2H11Ad
	9JEDZcEhq7kkwMIiGmZ1ZpWGxIttqHNEhqpeU=
Message-ID: <d8e7a1e30808220413s3e7c593fr7ee2be6af70ff1ca@mail.gmail.com>
Date: Fri, 22 Aug 2008 16:43:47 +0530
From: "c k" <shreeseva.learning@gmail.com>
To: pgsql-general@postgresql.org, pgsql-admin@postgresql.org
Subject: LIKE and SIMILAR TO
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_32831_19539851.1219403627055"

------=_Part_32831_19539851.1219403627055
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello all,
As we are migrating our ERP application from MySQL to PostgreSQL we have
some difficulties. One of them is use of Like and Similar to operators. We
often use LIKE to search a string from front-end without case sensetivity.
As postgreSQL's LIKE is case sensitive, we tried ILIKE and SIMILAR TO, but
both are slower than LIKE and we must need case insensitivity. How can we
get this by increases speed. All search columns are VARCHAR(100)to
VARCHAR(250). Currently without index.

Thanks,
CPK

------=_Part_32831_19539851.1219403627055
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Hello all,<br>As we are migrating our ERP application from MySQL to PostgreSQL we have some difficulties. One of them is use of Like and Similar to operators. We often use LIKE to search a string from front-end without case sensetivity. As postgreSQL&#39;s LIKE is case sensitive, we tried ILIKE and SIMILAR TO, but both are slower than LIKE and we must need case insensitivity. How can we get this by increases speed. All search columns are VARCHAR(100)to VARCHAR(250). Currently without index.<br>
<br>Thanks,<br>CPK<br></div>

------=_Part_32831_19539851.1219403627055--