i test it and now the error is
mhc2db=> select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as t1, precalc as t2 where t1.ce='ACIAD' and idr(t2.p1, t2.p4, t2.p6, t2.p7, t2.p9, 'HLA-DRB5*0101')>2;
ERROR: relation "pssms" does not exist
CONTEXT: SQL statement "SELECT score from PSSMS where AA= $1 and POS=1 and MOLEC= $2 "
PL/pgSQL function "idr" line 11 at select into variables
pssm was a temporary table that i used to calculate the index in precalc table with idr function, should i rebuilt it? the problem is that if i can't use idr as an index it eill be to slow
pau
2007/11/29, Richard Huxton < dev@archonet.com>:Pau Marc Munoz Torres wrote:
> Hi everybody
>
> I'm doing a two table query as follow
>
> mhc2db=> select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local
> as t1, precalc as t2 where t1.ce='ACIAD' and t2.idr(p1, p4, p6, p7, p9,
> 'HLA-DRB5*0101')>2;
>
> and i get the following error
>
> ERROR: schema "t2" does not exist
>
> but those tables exists!! and are as follow!!
You have t2.idr(...) which is being read as a function "idr" in schema "t2".
Did you mean idr(t2.p1, t2.p4, ...)?
--
Richard Huxton
Archonet Ltd
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)
telèfon: 93 5812807
Email :
paumarc.munoz@bioinf.uab.cat
