Question About UNION - Mailing list pgsql-general

From Bill Thoen
Subject Question About UNION
Date
Msg-id 48EE330B.20106@gisnet.com
Whole thread Raw
Responses Re: Question About UNION  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
I'm trying to combine two tables, but I only want unique records based
on the first two columns. Can UNION be used to join three-column tables
but only include records based on the uniqueness of the first two
columns? If not, how would I do this with PostgreSQL 8.1?


pgsql-general by date:

Previous
From: Markus Wanner
Date:
Subject: Re: Re: [Pkg-postgresql-public] Postgres major version support policy on Debian
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Re: [Pkg-postgresql-public] Postgres major version support policy on Debian