As of 7.4, this is a requirement badly in need of reconsideration.
What makes you think there is any function name involved? Consider
something like
create index i on t ((col + 2));
Getting the column names is still a sensible operation though. I'd
suggest looking in pg_depend to
Jakub [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I need to retrieve the name of the function and the index column names
of the functional index. The system information about the
index(function and its args) is stored in the system catalog column
pg_index.indexprs. Do I
Tom Hebbron [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]...
Jakub [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I need to retrieve the name of the function and the index column names
of the functional index. The system information about the
index(function and
Hi,
I need to retrieve the name of the function and the index column names
of the functional index. The system information about the
index(function and its args) is stored in the system catalog column
pg_index.indexprs. Do I have to parse pg_index.indexprs text or
[EMAIL PROTECTED] (Jakub) writes:
I need to retrieve the name of the function and the index column names
of the functional index. The system information about the
index(function and its args) is stored in the system catalog column
pg_index.indexprs.
As of 7.4, this is a requirement badly in