Re: select from an index - Mailing list pgsql-general

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