Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: See the WHERE clause of a partial index
Date
Msg-id 19433.1347650323@sss.pgh.pa.us
Whole thread Raw
In response to See the WHERE clause of a partial index  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: See the WHERE clause of a partial index
List pgsql-general
Tree view 
Paul Jungwirth <pj@illuminatedcomputing.com> writes:
> I'm not sure how to interpret that `indpred` column. Is there any way
> to reconstruct the WHERE clause I originally passed to the CREATE
> INDEX command?

pg_get_indexdef() should help.  If you really want just the WHERE
clause, possibly pg_get_expr() would work, but I've not tried it on
index clauses.

            regards, tom lane

pgsql-general by date:

Previous
From: Paul Jungwirth
Date:
Subject: See the WHERE clause of a partial index
Next
From: jam3
Date:
Subject: Re: Would my postgresql 8.4.12 profit from doubling RAM?