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 * from precalc where h2iab>2
>
> but obviously h2iab is not a column...
>
> some of you knows what i should do?
>
select * from precalc where idr(p1,p4,p6,p7,p9,'H-2*IAb') > 2
Cheers,
Steve