limit left join rows to 1

From: Jure Ložar <jure(dot)lozar(at)madalbal(dot)si>
To: pgsql-general(at)postgresql(dot)org
Subject: limit left join rows to 1
Date: 2006-10-31 15:56:40
Message-ID: 45477238.4050202@madalbal.si
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

Is it possible to limit number of left join rows that match condition to
1? I don't want to have hits from first table multiplied when more then
1 row matches on left join condition.

Thank you
Jure

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darcy Buskermolen 2006-10-31 16:14:39 Re: [HACKERS] Index greater than 8k
Previous Message Tom Lane 2006-10-31 14:57:46 Re: WAL Archiving under Windows