Re: BUG #14601: Alternative support for amcanorder column under pg_am

Thanks Guys.

Regards,
Prajval Poojari

-----Original Message-----
From: Andrew Gierth [mailto:andrew(at)tao11(dot)riddles(dot)org(dot)uk]
Sent: Tuesday, March 28, 2017 4:49 PM
To: Prajval Poojari <ppoojari(at)erwin(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #14601: Alternative support for amcanorder column under pg_am

>>>>> "ppoojari" == ppoojari <ppoojari(at)erwin(dot)com> writes:

ppoojari> In 9.6 when i tried to use amcanorder column under pg_am it ppoojari> gives me an error stating column doesnt not exist.

This is not a bug.

ppoojari> Can you please provide me with some information if any ppoojari> alternative solution is provided for this feature ?

select amname, pg_indexam_has_property(oid, 'can_order') as amcanorder
from pg_am;

See https://www.postgresql.org/docs/9.6/static/functions-info.html#FUNCTIONS-INFO-INDEXAM-PROPS

--
Andrew (irc:RhodiumToad)