| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: JDBC driver and Postgres 9.6beta |
| Date: | 2016-05-17 06:10:53 |
| Message-ID: | nhecld$kvinhecld$kvi$1@ger.gmane.org@ger.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2016-05-17 10:27:57 | Re: JDBC driver and Postgres 9.6beta |
| Previous Message | Tom Lane | 2016-05-14 14:49:28 | Re: JDBC driver and Postgres 9.6beta |