From: Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
To: pgsql-sql@postgresql.org
Subject: Re: "compressing" consecutive values into one
Date: Tue, 23 Nov 2010 19:13:29 +0100
Message-ID: <20101123181329.GA22721@apartia.fr> (raw)
In-Reply-To: <5678C0F3BD5E48F587D8065C9C38BAA9@marktestcr.marktest.pt>
References: <20101123151918.GA22094@apartia.fr>
<5678C0F3BD5E48F587D8065C9C38BAA9@marktestcr.marktest.pt>
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,
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vindex+lists-pgsql-sql@apartia.org
Subject: Re: "compressing" consecutive values into one
In-Reply-To: <20101123181329.GA22721@apartia.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox