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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
