Re: SQL question - duplicate records from join - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: SQL question - duplicate records from join
Date
Msg-id 3C88AB9C.24843.961AC1@localhost
Whole thread Raw
In response to Re: SQL question - duplicate records from join  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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@iol.ie                      The Irish Pipe Organ Page
---------------------------------------------------------


pgsql-general by date:

Previous
From: rolf.ostvik@axxessit.no
Date:
Subject: Re: PL/pgSQL Syntax Problem
Next
From: Jeff Self
Date:
Subject: Re: PostgreSQL for PS/2 ?