Re: "compressing" consecutive values into one

From: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: "compressing" consecutive values into one
Date: 2010-11-23 18:13:29
Message-ID: 20101123181329.GA22721@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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,

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message bricklen 2010-11-23 18:19:45 Re: "compressing" consecutive values into one
Previous Message Oliveiros d'Azevedo Cristina 2010-11-23 15:31:59 Re: "compressing" consecutive values into one