Re: Planner not using UNIQUEness of index properly - Mailing list pgsql-general

From John Burger
Subject Re: Planner not using UNIQUEness of index properly
Date
Msg-id 1A810F50-1B24-4623-A708-AB79A0EAA668@mitre.org
Whole thread Raw
In response to Re: Planner not using UNIQUEness of index properly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

>> I would think UNIQUE => one row is pretty obvious - what am I
>> missing?  (Unless it's that I'm still stuck in 7.4.)
>
> That would be the problem :-( ... a look at the code suggests that the
> ability to do anything intelligent with expression indexes was added
> in 8.0.

Whaa.  Okay, more ammunition, thanks.

- John D. Burger
   MITRE



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Simpler dump?
Next
From: Richard Huxton
Date:
Subject: Re: Simpler dump?