Re: type-casting and LIKE queries

On Sun, Mar 16, 2003 at 09:05:52PM -0500, valerian wrote:
> On Sun, Mar 16, 2003 at 07:34:37PM -0500, valerian wrote:

> So that takes care of the first two types of queries, but not the one
> that has a % both at the beginning and end of the search key.
>
> Any ideas on how to handle those?

I don't think there's a way to handle expressions with that level of
generality.

Actually there are ways using suffix tries or some such structure, but
there's no implementation of that in Postgres. I don't know if that
kind of thing is doable with GiST indexes; should be, at least in
theory. If you want to do it, it's going to cost a nontrivial amount of
work.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)