Re: SQL question - duplicate records from join

From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL question - duplicate records from join
Date: 2002-03-08 12:16:28
Message-ID: 3C88AB9C.24843.961AC1@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4 Mar 2002 at 8:22, Stephan Szabo wrote:

> I recently upgraded to Postgres 7.1 (having finally found the
> correct pg_dump!), and now I notice that joins are returning
> duplicate records. A typical query would be:

I got it sorted - it turned out that there was some ambiguity in the
values being used to join tables.

Sincere thanks to all who replied, both on- and off-list!

--Ray.

---------------------------------------------------------
Raymond O'Donnell http://www.iol.ie/~rod/organ
rod(at)iol(dot)ie The Irish Pipe Organ Page
---------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mdb 2002-03-08 14:45:48 Re: Temp Tables
Previous Message =?ISO-8859-1?Q?Enrique_Ariz=F3n_Benito?= 2002-03-08 10:48:07 Modifying text data?