On May 21, 2008, at 8:23 AM, Sim Zacks wrote:
We are testing dbmail on postgresql, which uses a bytea column to
store
the messages. Because of this searching through messages is case
sensitive.
Does anyone know of a way to make it not case-sensitive, either by
changing the data type (obviously without breaking the current
functionality) or a Select Rule or any other method?
My suggestion would be to write a trigger and use tsearch to setup a
full text index. Even if you manage a case-insensitive search method,
I doubt it will be useful unless you always plan to have a small
number of messages to search.
John DeSoi, Ph.D.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
