Re: [GENERAL] select from an index

2008-05-06 Thread Pau Marc Munoz Torres
Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb')); , where idr is a function that returns a real number,as a result i got the following table mhc2db=> \d precalc; Table

Re: [GENERAL] select from an index

2007-11-27 Thread Steve Atkins
On Nov 27, 2007, at 3:15 AM, Pau Marc Munoz Torres wrote: Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));, now, i would like to perform a query using this index, something like Select

[GENERAL] select from an index

2007-11-27 Thread Pau Marc Munoz Torres
Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));, where idr is a function that returns a real number, as a result i got the following table mhc2db=> \d precalc; Tab