On 6/26/07, Rafal Pietrak <[EMAIL PROTECTED]> 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
