Postgres Pro
Downloads
Home   >   mailing lists

Understanding how partial indexes work? - Mailing list pgsql-general

From Chris Velevitch
Subject Understanding how partial indexes work?
Date
Msg-id b0a3bf780712052344n5b6b8d46tac80a0f1ee4944ab@mail.gmail.com
Whole thread Raw
Responses Re: Understanding how partial indexes work?
Re: Understanding how partial indexes work?
List pgsql-general
Tree view 
I have a query on a table:-

     X between k1 and k2 or X < k1 and Y <> k3

where k1, k2, k3 are constants.

How would this query work, if I created an index on X and a partial
index on X where Y <> k3?


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
m: 0415 469 095
www.flashdev.org.au

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: elegant way to fill a table with serial
Next
From: Marco Curtolo
Date:
Subject: Import LDAP data to a Postgres database