Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 31 Oct 2006 16:56:40 +0100
- Message-id: <45477238(dot)4050202(at)madalbal(dot)si>
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
- Follow-Ups:
- Re: limit left join rows to 1
- From: Andreas Kretschmer
- Re: limit left join rows to 1
- Prev by Date: Re: [HACKERS] Index greater than 8k
- Next by Date: updating to 7.4.13 helped it appears
- Previous by thread: postgres import
- Next by thread: Re: limit left join rows to 1
- Indexes: