Re: See the WHERE clause of a partial index - Mailing list pgsql-general

> It'd be great to get just the WHERE clause if possible, although I can
> work around it if not. I couldn't find much documentation re
> pg_get_expr.

To answer my own question, this works:

    > select pg_get_expr(indpred, indrelid) from pg_index where
indexrelid = 223630;
         pg_get_expr
    ----------------------
     (deleted_at IS NULL)
    (1 row)

So I guess the problem was trying to get a pg_node_tree out of a string.

Thanks again!
Paul

--
_________________________________
Pulchritudo splendor veritatis.