| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: bytea case sensitivity |
| Date: | 2008-05-21 14:11:13 |
| Message-ID: | 988DF772-0EA1-4978-9964-C2EBF0FAD03B@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2008-05-21 14:12:09 | Fwd: sql_type tinterval not supported by DBD::Pg |
| Previous Message | Roberts, Jon | 2008-05-21 13:09:43 | Re: best er modeling tool for postgreSQL |