Vladimir Sitnikov schrieb am 14.05.2016 um 15:57: > Thanks for the report, > > I've commented out amcanorder for 9.6 here: https://github.com/pgjdbc/pgjdbc/pull/560 > > Does anybody know what is the proper way to tell if index column is ASC or DESC in 9.6+?
Based on Tom's statement that only btree indexes can be sorted, the following seems better then just returning NULL:
CASE am.amname WHEN 'btree' THEN CASE i.indoption[(i.keys).n - 1] & 1 WHEN 1 THEN 'D' ELSE 'A' END ELSE NULL END AS ASC_OR_DESC,