Skip site navigation (1)
Skip section navigation (2)
On 6/26/07, Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> wrote:
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
Peripheral Links
Header And Logo
|
Site Navigation
Re: a JOIN on same table, but 'slided over'
- From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
- To: "Rafal Pietrak" <rafal(at)zorro(dot)isa-geek(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: a JOIN on same table, but 'slided over'
- Date: Tue, 26 Jun 2007 10:06:43 +0200
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: Rafal Pietrak
- Re: a JOIN on same table, but 'slided over'
- References:
- a JOIN on same table, but 'slided over'
- From: Rafal Pietrak
- a JOIN on same table, but 'slided over'
- Prev by Date: a JOIN on same table, but 'slided over'
- Next by Date: Re: data partitions across different nodes
- Previous by thread: a JOIN on same table, but 'slided over'
- Next by thread: Re: a JOIN on same table, but 'slided over'
- Indexes: