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