Re: Making a query from 2 tables at same time

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(at)archonet(dot)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(dot)munoz(at)bioinf(dot)uab(dot)cat