Query question

From: Stéphane RIFF <stephane(dot)riff(at)cerene(dot)fr>
To: pgsql-sql(at)postgresql(dot)org
Subject: Query question
Date: 2005-04-20 16:11:40
Message-ID: 42667F3C.6080303@cerene.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi ,

I have table that represent a switch activity like this :

| date | state |
| 2005-04-20 17:00:00 | 0 |
| 2005-04-20 17:00:15 | 0 |
| 2005-04-20 17:00:30 | 1 |
| 2005-04-20 17:00:45 | 1 |
| 2005-04-20 17:01:00 | 1 |
| 2005-04-20 17:01:15 | 0 |
| 2005-04-20 17:01:30 | 0 |
| 2005-04-20 17:01:45 | 0 |

I want to get the date of each states change but i not a sql expert.
Can someone advices me

Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Franco Bruno Borghesi 2005-04-20 17:35:56 Re: Query question
Previous Message Tom Lane 2005-04-20 16:02:34 Re: Odd error message (" hash indexes do not support whole-index scans")