Re: Making a query from 2 tables at same time - Mailing list pgsql-general

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