Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: a JOIN on same table, but 'slided over'
- From: Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com>
- To: hubert depesz lubaczewski <depesz(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: a JOIN on same table, but 'slided over'
- Date: Tue, 26 Jun 2007 14:28:27 +0200
Marvelous! Thenx! -R On Tue, 2007-06-26 at 10:06 +0200, hubert depesz lubaczewski wrote: > On 6/26/07, Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> wrote: > Is there an SQL construct to get it? > > select > distinct on (t1.id) > t1.*, t2.* > from > test t1 > join test t2 on t2.id > t1.id > order by t1.id asc, t2.id asc > > should do the trick. > > depesz > > -- > http://www.depesz.com/ - nowy, lepszy depesz
- Follow-Ups:
- Re: a JOIN on same table, but 'slided over'
- From: Gurjeet Singh
- Re: a JOIN on same table, but 'slided over'
- References:
- a JOIN on same table, but 'slided over'
- From: Rafal Pietrak
- Re: a JOIN on same table, but 'slided over'
- From: hubert depesz lubaczewski
- a JOIN on same table, but 'slided over'
- Prev by Date: Re: varchar(n) VS text
- Next by Date: Re: a JOIN on same table, but 'slided over'
- Previous by thread: Re: a JOIN on same table, but 'slided over'
- Next by thread: Re: a JOIN on same table, but 'slided over'
- Indexes: