Question About UNION

From: Bill Thoen <bthoen(at)gisnet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question About UNION
Date: 2008-10-09 16:36:27
Message-ID: 48EE330B.20106@gisnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2008-10-09 16:38:57 Re: Re: [Pkg-postgresql-public] Postgres major version support policy on Debian
Previous Message Markus Wanner 2008-10-09 16:35:40 Re: Re: [Pkg-postgresql-public] Postgres major version support policy on Debian