> 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