| From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | bytea case sensitivity |
| Date: | 2008-05-21 12:23:32 |
| Message-ID: | g1148b$23dh$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sim Zacks | 2008-05-21 12:36:22 | Re: Corrupted database's files (linux RAID5 + PostgreSQL 8.3.0) |
| Previous Message | David Fetter | 2008-05-21 12:00:51 | Re: Short-circuiting FK check for a newly-added field |