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

From Alvaro Herrera
Subject Re: No longer possible to query catalogs for index capabilities?
Date
Msg-id 20160808045358.GA877101@alvherre.pgsql
Whole thread Raw
In response to Re: No longer possible to query catalogs for index capabilities?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: No longer possible to query catalogs for index capabilities?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: No longer possible to query catalogs for index capabilities?  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-hackers
Tom Lane wrote:

> Building on the has-property approach Andrew suggested, I wonder if
> we need something like pg_index_column_has_property(indexoid, colno,
> propertyname) with properties like "sortable", "desc", "nulls first".

This seems simple enough, on the surface.  Why not run with this design?

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



pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Oddity in EXPLAIN for foreign/custom join pushdown plans
Next
From: Amit Langote
Date:
Subject: Re: Declarative partitioning