On Sun, 1 Jan 2012 16:12:10 +0100
Andreas Kretschmer <akretschmer(at)spamfence(dot)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
Aïe I missed this one; that was my conclusion but I wanted to make
Alimony is the curse of the writing classes.
-- Norman Mailer
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2012-01-01 18:01:58|
|Subject: Re: How to declare a variable in a postgresql query in sql language ? |
|Previous:||From: Andreas Kretschmer||Date: 2012-01-01 15:12:10|
|Subject: Re: is it normal behavior of index?|