| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Making a query from 2 tables at same time |
| Date: | 2007-11-29 15:10:53 |
| Message-ID: | 20071129151053.GG30130@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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,
> 'HLA-DRB5*0101')>2;
>
> and i get the following error
>
> ERROR: schema "t2" does not exist
>
> but those tables exists!! and are as follow!!
The error-message means the function-call t2.idr(...), this is wrong.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pau Marc Munoz Torres | 2007-11-29 15:11:37 | Re: Making a query from 2 tables at same time |
| Previous Message | Glyn Astill | 2007-11-29 15:01:59 | Re: Slony-I creation scripts not available |