Re: Partitioned tables and covering indexes - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Partitioned tables and covering indexes
Date
Msg-id 641a91aa-19ef-e092-dd4c-2554487169fc@2ndquadrant.com
Whole thread Raw
In response to Re: Partitioned tables and covering indexes  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Partitioned tables and covering indexes
List pgsql-hackers
On 4/11/18 17:38, Peter Geoghegan wrote:
> On Wed, Apr 11, 2018 at 2:29 PM, Peter Eisentraut
> <peter.eisentraut@2ndquadrant.com> wrote:
>> But in this case it doesn't even do equality comparison, it just returns
>> the value.
> 
> That's the idea that I tried to express. The point is that we need to
> tell the user that there is no need to worry about it, rather than
> that they're wrong to ask about it. Though we should probably actually
> just throw an error.

Or maybe it should be the collation of the underlying table columns.
Otherwise the collation returned by an index-only scan would be
different from a table scan, no?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Fix for pg_stat_activity putting client hostaddr into appnamefield
Next
From: Teodor Sigaev
Date:
Subject: Re: Partitioned tables and covering indexes