Re: Query to retrieve the index columns when a function is used.

2020-03-11 Thread Tom Lane
David Rowley writes: > On Tue, 10 Mar 2020 at 02:16, Sterpu Victor wrote: >> How can I retrieve this detail? > Those details are in the indexprs column. There's an item there for > each 0 valued indkey. It's not going to be particularly easy for you > to parse that from SQL. Internally in Post

Re: Query to retrieve the index columns when a function is used.

2020-03-11 Thread David Rowley
On Tue, 10 Mar 2020 at 02:16, Sterpu Victor wrote: > I'm testing on Postgresql 12.1 and I have a index like this: > "check_dates_gist" EXCLUDE USING gist (id_test1 WITH =, id_test2 WITH =, > tsrange(valid_from::timestamp without time zone, valid_to::timestamp without > time zone) WITH &&) > > Wh

Query to retrieve the index columns when a function is used.

2020-03-09 Thread Sterpu Victor
Hello I'm testing on Postgresql 12.1 and I have a index like this: "check_dates_gist" EXCLUDE USING gist (id_test1 WITH =, id_test2 WITH =, tsrange(valid_from::timestamp without time zone, valid_to::timestamp without time zone) WITH &&) When I run this query: "select pc.relname, pi.indisuni