On Jan 10, 2013, at 2:16 PM, Tom Lane wrote:
>> Is there some way to only get the relevant index expression from indexprs,
>> rather than the whole expression?
>
> pg_get_indexdef() is your friend. You really, really don't want to
> write any client-side code that inspects indexprs directly.
"David E. Wheeler" writes:
> Is there some way to only get the relevant index expression from indexprs,
> rather than the whole expression?
pg_get_indexdef() is your friend. You really, really don't want to
write any client-side code that inspects indexprs directly. It'll
break.
Hackers,
I'm trying to write a query to give me a list of the columns and/or expressions
in an index. For example, given this table:
david=# \d foo
Table "public.foo"
Column | Type| Modifiers
-+---+---
id | integer |
bar_ids | integer[] |
Indexe