Re: Making a query from 2 tables at same time

Pau Marc Munoz Torres wrote:
> 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

I think you need to take a step back and explain what it is you are
trying to do - you shouldn't be using an external table in an indexed
function at all.

--
   Richard Huxton
   Archonet Ltd