Postgres Pro
Downloads
Home   >   mailing lists

is it normal behavior of index? - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject is it normal behavior of index?
Date
Msg-id 20120101060839.7d247244@anubis.defcon1
Whole thread Raw
Responses Re: is it normal behavior of index?  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
Tree view 
Hi list,

Simple test table w/ a varchar(32): if I create an index with
'varchar_pattern_ops' explain says it is NOT used in my query;
if I create it without it is used (?!)

JY
--
Knocked, you weren't in.
        -- Opportunity

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: strange order by
Next
From: Sara Harris
Date:
Subject: How to declare a variable in a postgresql query in sql language ?