Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 288491336B42 for ; Tue, 23 Nov 2010 14:12:24 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 92492-03 for ; Tue, 23 Nov 2010 18:12:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zenon.apartia.fr (zenon.apartia.fr [82.66.93.83]) by mail.postgresql.org (Postfix) with ESMTP id 325D91337B4E for ; Tue, 23 Nov 2010 14:12:16 -0400 (AST) Date: Tue, 23 Nov 2010 19:13:29 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: Re: "compressing" consecutive values into one Message-ID: <20101123181329.GA22721@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org References: <20101123151918.GA22094@apartia.fr> <5678C0F3BD5E48F587D8065C9C38BAA9@marktestcr.marktest.pt> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5678C0F3BD5E48F587D8065C9C38BAA9@marktestcr.marktest.pt> User-Agent: Mutt/1.5.21 (2010-09-15) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.225 tagged_above=-5 required=5 tests=BAYES_05=-0.5, TO_NO_BRKTS_DIRECT=1.725 X-Spam-Level: * X-Archive-Number: 201011/50 X-Sequence-Number: 34788 On Tue, Nov 23, 2010 at 03:31:59PM -0000, Oliveiros d'Azevedo Cristina wrote: > Salut, Louis-David, > > Can you please state the columns belonging to price table > and give a concrete example? > Say, data before and data after you want to do? Hi Cristina, Data before: id_price | price ---------------- 1 | 23 3 | 45 4 | 45 6 | 45 8 | 45 9 | 89 Data after: id_price | price ---------------- 1 | 23 8 | 45 9 | 89 Thanks,