Search Postgresql Archives

Re: Making a query from 2 tables at same time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx>:
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@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux