Search Postgresql Archives

bytea case sensitivity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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-----


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux