Re: See the WHERE clause of a partial index

[Paul Jungwirth <pj@xxxxxxxxxxxxxxxxxxxxxxxx>]

> 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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general