[GENERAL] complex query using postgresql

2008-04-30 Thread Pau Marc Munoz Torres
Hi everybody I have de following table where i can perform two different queries: select * from precalc where idr(p1, p4, p6, p7, p9, 'HLA-DR7')2; where idr is a function used to create indicies and select * from precalc where p1='S'; Now i would like to perform a query as : select * from

Re: [GENERAL] complex query using postgresql

2008-04-30 Thread Alban Hertroys
On Apr 30, 2008, at 11:50 AM, Pau Marc Munoz Torres wrote: Hi everybody I have de following table where i can perform two different queries: select * from precalc where idr(p1, p4, p6, p7, p9, 'HLA-DR7')2; where idr is a function used to create indicies Are your indices generated by the