Re: [HACKERS] How to retrieve functional index column names

2004-01-18 Thread Jakub
> 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

Re: [HACKERS] How to retrieve functional index column names

2004-01-11 Thread Jakub
"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 > >

Re: [HACKERS] How to retrieve functional index column names

2004-01-11 Thread Tom Hebbron
"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.

Re: [HACKERS] How to retrieve functional index column names

2004-01-08 Thread Tom Lane
[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