Pau Marc Munoz Torres wrote:
Ok,
I have two tables, first one, that i call precalc has the following
structure
...
and a numer of index that is a real number resulting of a function (function
is called idr and i talk about it bellow)
...
another table is local than has the following fields
This is the problem:
> ... t2.idr(p1, p4, p6, p7, p9, 'HLA-DRB5*0101')>2;
What is that t2.idr ? Based on the syntax postgres must look for a
function (because of the parentheses), and it thinks t2 is the schema
where it must look for it.
Cheers,
Csaba.
---(end of broad
Ok,
I have two tables, first one, that i call precalc has the following
structure
id . serial
p1 varchar
p4 varchar
p6 varchar
p7 varchar
p9 varchar
and a numer of index that is a real number resulting of a function (function
is called idr and i talk about it bellow)
another table is loca
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 st
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 PSS
am Thu, dem 29.11.2007, um 15:48:45 +0100 mailte Pau Marc Munoz Torres
folgendes:
> 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,
>
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
