"Alexander Zhiltsov" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings