Re: No longer possible to query catalogs for index capabilities? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: No longer possible to query catalogs for index capabilities?
Date
Msg-id 4dea49ae-3110-5e97-1548-24ddf8f07c34@2ndquadrant.com
Whole thread Raw
In response to Re: No longer possible to query catalogs for index capabilities?  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: No longer possible to query catalogs for index capabilities?
List pgsql-hackers
On 7/25/16 3:26 PM, Andrew Gierth wrote:
> The issue I ran into was the exact same one as in the JDBC thread I
> linked to earlier: correctly interpreting pg_index.indoption (to get the
> ASC / DESC and NULLS FIRST/LAST settings), which requires knowing
> whether amcanorder is true to determine whether to look at the bits at
> all.

Maybe we should provide a facility to decode those bits then?

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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposal: revert behavior of IS NULL on row types
Next
From: Tom Lane
Date:
Subject: Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE