Обсуждение: bytea case sensitivity

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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?

Thank you
Sim Zacks
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkg0FEQACgkQjDX6szCBa+psNACeK4ysL2DFBW41+Ara+r+0z1xK
RAQAoLqhnWBQOHarZfgRWijOkwgzXooi
=LViA
-----END PGP SIGNATURE-----

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.