Re: Making a query from 2 tables at same time

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Pau Marc Munoz Torres <paumarc(at)gmail(dot)com>
Cc: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Making a query from 2 tables at same time
Date: 2007-11-29 16:31:07
Message-ID: 1196353867.31315.36.camel@PCD12478
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pepe Barbe 2007-11-29 16:31:59 Problems Dumping DB
Previous Message Andrew Sullivan 2007-11-29 16:30:54 Re: HD is flooded by Error Log info