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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
