Re: is it normal behavior of index?

On Sun, 1 Jan 2012 16:12:10 +0100
Andreas Kretschmer <akretschmer@spamfence.net> wrote:

>
> I think, in this case you needs 2 indexes, one with and one without the
> opclass - option.
>
......
> Note that you should also create an index with the default operator
> class if you want queries involving ordinary <, <=, >, or >= comparisons
> to use an index. Such queries cannot use the xxx_pattern_ops operator
> classes.

Aïe I missed this one; that was my conclusion but I wanted to make
absolutely sure.
Thanks Andreas.
JY
--
Alimony is the curse of the writing classes.
        -- Norman Mailer