Re: JDBC driver and Postgres 9.6beta

see https://github.com/pgjdbc/pgjdbc/pull/569

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

On 17 May 2016 at 02:10, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> 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,
>
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>