"Alexander Zhiltsov" <ayz(at)ems(dot)ru> writes:
> Executing the following query return an error 'ERROR: unrecognized node ty=
> pe: 656'.
> SELECT pg_get_expr(i.indexprs, i.indrelid) AS expr
> FROM pg_index i
> INNER JOIN pg_class c ON i.indrelid =3D c.oid
> WHERE c.relname =3D 'art'
I'm not convinced this is really a bug, because pg_index.indexprs is not
an expression (it's a list of expressions) and so it's not clear that
pg_get_expr should be expected to work on it. What result were you
expecting to get?
regards, tom lane