> 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_depen
"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
> >
"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.
[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 i
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
pg_get_indexdef(pg_index.indexreli
