bytea case sensitivity - Mailing list pgsql-general

From Sim Zacks
Subject bytea case sensitivity
Date
Msg-id g1148b$23dh$1@news.hub.org
Whole thread Raw
Responses Re: bytea case sensitivity  (John DeSoi <desoi@pgedit.com>)
List pgsql-general
-----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-----

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: Corrupted database's files (linux RAID5 + PostgreSQL 8.3.0)
Next
From: "Roberts, Jon"
Date:
Subject: Re: best er modeling tool for postgreSQL