complex query using postgresql

------=_Part_536_4304175.1209549033674
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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=3D'S';

Now i would like to perform a query as :

select * from precalc where idr(p1, p4, p6, p7, p9, 'HLA-DR7')>2 and
p1=3D'S'...;


but i don't know how

any body can help me?

thanks


 Column |     Type     |                      Modifiers
--------+--------------+---------------------------------------------------=
---
 id     | integer      | not null default
nextval('precalc_id_seq'::regclass)
 p1     | character(1) |
 p4     | character(1) |
 p6     | character(1) |
 p7     | character(1) |
 p9     | character(1) |
Indexes:
    "h2iab" btree (idr(p1, p4, p6, p7, p9, 'H-2*IAb'::character varying))
    "h2iad" btree (idr(p1, p4, p6, p7, p9, 'H-2*IAd'::character varying))
    "h2iak" btree (idr(p1, p4, p6, p7, p9, 'H-2*IAk'::character varying))
    "h2ied" btree (idr(p1, p4, p6, p7, p9, 'H-2*IEd'::character varying))
    "hladqa10501" btree (idr(p1, p4, p6, p7, p9,
'HLA-DQA1*0501'::character
varying))
    "hladqb10201" btree (idr(p1, p4, p6, p7, p9,
'HLA-DQB1*0201'::character
varying))
    "hladr" btree (idr(p1, p4, p6, p7, p9, 'HLA-DR'::character varying))
    "hladr1" btree (idr(p1, p4, p6, p7, p9, 'HLA-DR1'::character varying))
    "hladr13" btree (idr(p1, p4, p6, p7, p9, 'HLA-DR13'::character
varying)=
)
    "hladr3" btree (idr(p1, p4, p6, p7, p9, 'HLA-DR3'::character varying))
    "hladr7" btree (idr(p1, p4, p6, p7, p9, 'HLA-DR7'::character varying))
    "hladrb10101" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0101'::character
varying))
    "hladrb10102" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0102'::character
varying))
    "hladrb10301" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0301'::character
varying))
    "hladrb10302" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0302'::character
varying))
    "hladrb10401" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0401'::character
varying))
    "hladrb10402" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0402'::character
varying))
    "hladrb10701" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0701'::character
varying))
    "hladrb10802" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0802'::character
varying))
    "hladrb10901" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*0901'::character
varying))
    "hladrb11101" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*1101'::character
varying))
    "hladrb11102" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*1102'::character
varying))
    "hladrb11103" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*1103'::character
varying))
    "hladrb11104" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*1104'::character
varying))
    "hladrb11301" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*1301'::character
varying))
    "hladrb11302" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*1302'::character
varying))
    "hladrb11501" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB1*1501'::character
varying))
    "hladrb40101" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB4*0101'::character
varying))
    "hladrb50101" btree (idr(p1, p4, p6, p7, p9,
'HLA-DRB5*0101'::character
varying))
    "iid" btree (id)
    "ip1" btree (p1)
    "ip4" btree (p4)
    "ip6" btree (p6)
    "ip7" btree (p7)
    "ip9" btree (p9)


--=20
Pau Marc Mu=F1oz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

tel=E8fon: 93 5812807
Email : paumarc.munoz@[EMAIL PROTECTED]
 text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi everybody<br><br>&nbsp; I have de following table where i can perform
tw=
o different queries:<br><br>select * from precalc where idr(p1, p4, p6,
p7,=
 p9, &#39;HLA-DR7&#39;)&gt;2; where idr is a function used to create
indici=
es<br>

<br>and<br><br>select * from precalc where p1=3D&#39;S&#39;;<br><br>Now i
w=
ould like to perform a query as :<br><br>select * from precalc where
idr(p1=
, p4, p6, p7, p9, &#39;HLA-DR7&#39;)&gt;2 and p1=3D&#39;S&#39;...;<br><br>
<br>
but i don&#39;t know how<br><br>any body can help
me?<br><br>thanks<br><br>=
&nbsp;<br>&nbsp;Column |&nbsp;&nbsp;&nbsp;&nbsp;
Type&nbsp;&nbsp;&nbsp;&nbs=
p;
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Modifiers<br>------=
--+--------------+------------------------------------------------------<br=
>

&nbsp;id&nbsp;&nbsp;&nbsp;&nbsp; | integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
=
not null default
nextval(&#39;precalc_id_seq&#39;::regclass)<br>&nbsp;p1&nb=
sp;&nbsp;&nbsp;&nbsp; | character(1) |<br>&nbsp;p4&nbsp;&nbsp;&nbsp;&nbsp;
=
| character(1) |<br>&nbsp;p6&nbsp;&nbsp;&nbsp;&nbsp; | character(1)
|<br>&n=
bsp;p7&nbsp;&nbsp;&nbsp;&nbsp; | character(1)
|<br>&nbsp;p9&nbsp;&nbsp;&nbs=
p;&nbsp; | character(1) |<br>

Indexes:<br>&nbsp;&nbsp;&nbsp; &quot;h2iab&quot; btree (idr(p1, p4, p6,
p7,=
 p9, &#39;H-2*IAb&#39;::character varying))<br>&nbsp;&nbsp;&nbsp;
&quot;h2i=
ad&quot; btree (idr(p1, p4, p6, p7, p9, &#39;H-2*IAd&#39;::character
varyin=
g))<br>&nbsp;&nbsp;&nbsp; &quot;h2iak&quot; btree (idr(p1, p4, p6, p7, p9,
=
&#39;H-2*IAk&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;h2ied&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;H-=
2*IEd&#39;::character varying))<br>&nbsp;&nbsp;&nbsp;
&quot;hladqa10501&quo=
t; btree (idr(p1, p4, p6, p7, p9, &#39;HLA-DQA1*0501&#39;::character
varyin=
g))<br>&nbsp;&nbsp;&nbsp; &quot;hladqb10201&quot; btree (idr(p1, p4, p6,
p7=
, p9, &#39;HLA-DQB1*0201&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;hladr&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;HL=
A-DR&#39;::character varying))<br>&nbsp;&nbsp;&nbsp; &quot;hladr1&quot;
btr=
ee (idr(p1, p4, p6, p7, p9, &#39;HLA-DR1&#39;::character
varying))<br>&nbsp=
;&nbsp;&nbsp; &quot;hladr13&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;HLA-D=
R13&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;hladr3&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;H=
LA-DR3&#39;::character varying))<br>&nbsp;&nbsp;&nbsp; &quot;hladr7&quot;
b=
tree (idr(p1, p4, p6, p7, p9, &#39;HLA-DR7&#39;::character
varying))<br>&nb=
sp;&nbsp;&nbsp; &quot;hladrb10101&quot; btree (idr(p1, p4, p6, p7, p9,
&#39=
;HLA-DRB1*0101&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;hladrb10102&quot; btree (idr(p1, p4, p6, p7, p9,
&=
#39;HLA-DRB1*0102&#39;::character varying))<br>&nbsp;&nbsp;&nbsp;
&quot;hla=
drb10301&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;HLA-DRB1*0301&#39;::char=
acter varying))<br>&nbsp;&nbsp;&nbsp; &quot;hladrb10302&quot; btree
(idr(p1=
, p4, p6, p7, p9, &#39;HLA-DRB1*0302&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;hladrb10401&quot; btree (idr(p1, p4, p6, p7, p9,
&=
#39;HLA-DRB1*0401&#39;::character varying))<br>&nbsp;&nbsp;&nbsp;
&quot;hla=
drb10402&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;HLA-DRB1*0402&#39;::char=
acter varying))<br>&nbsp;&nbsp;&nbsp; &quot;hladrb10701&quot; btree
(idr(p1=
, p4, p6, p7, p9, &#39;HLA-DRB1*0701&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;hladrb10802&quot; btree (idr(p1, p4, p6, p7, p9,
&=
#39;HLA-DRB1*0802&#39;::character varying))<br>&nbsp;&nbsp;&nbsp;
&quot;hla=
drb10901&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;HLA-DRB1*0901&#39;::char=
acter varying))<br>&nbsp;&nbsp;&nbsp; &quot;hladrb11101&quot; btree
(idr(p1=
, p4, p6, p7, p9, &#39;HLA-DRB1*1101&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;hladrb11102&quot; btree (idr(p1, p4, p6, p7, p9,
&=
#39;HLA-DRB1*1102&#39;::character varying))<br>&nbsp;&nbsp;&nbsp;
&quot;hla=
drb11103&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;HLA-DRB1*1103&#39;::char=
acter varying))<br>&nbsp;&nbsp;&nbsp; &quot;hladrb11104&quot; btree
(idr(p1=
, p4, p6, p7, p9, &#39;HLA-DRB1*1104&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;hladrb11301&quot; btree (idr(p1, p4, p6, p7, p9,
&=
#39;HLA-DRB1*1301&#39;::character varying))<br>&nbsp;&nbsp;&nbsp;
&quot;hla=
drb11302&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;HLA-DRB1*1302&#39;::char=
acter varying))<br>&nbsp;&nbsp;&nbsp; &quot;hladrb11501&quot; btree
(idr(p1=
, p4, p6, p7, p9, &#39;HLA-DRB1*1501&#39;::character varying))<br>

&nbsp;&nbsp;&nbsp; &quot;hladrb40101&quot; btree (idr(p1, p4, p6, p7, p9,
&=
#39;HLA-DRB4*0101&#39;::character varying))<br>&nbsp;&nbsp;&nbsp;
&quot;hla=
drb50101&quot; btree (idr(p1, p4, p6, p7, p9,
&#39;HLA-DRB5*0101&#39;::char=
acter varying))<br>&nbsp;&nbsp;&nbsp; &quot;iid&quot; btree (id)<br>

&nbsp;&nbsp;&nbsp; &quot;ip1&quot; btree (p1)<br>&nbsp;&nbsp;&nbsp;
&quot;i=
p4&quot; btree (p4)<br>&nbsp;&nbsp;&nbsp; &quot;ip6&quot; btree
(p6)<br>&nb=
sp;&nbsp;&nbsp; &quot;ip7&quot; btree (p7)<br>&nbsp;&nbsp;&nbsp;
&quot;ip9&=
quot; btree (p9)<br><br>&nbsp;<br>-- <br>Pau Marc Mu=F1oz
Torres<br><br>Lab=
oratori de Biologia Computacional <br>

Institut de Biotecnologia i Biomedicina Vicent Villar <br>Universitat
Auton=
oma de Barcelona<br>E-08193 Bellaterra (Barcelona)<br> <br>tel=E8fon: 93
58=
12807<br>Email : paumarc.munoz@[EMAIL PROTECTED]