Postgres Pro
Downloads
Home   >   mailing lists

Query question - Mailing list pgsql-sql

From Stéphane RIFF
Subject Query question
Date
Msg-id 42667F3C.6080303@cerene.fr
Whole thread Raw
Responses Re: Query question
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Odd error message (" hash indexes do not support whole-index scans")
Next
From: Franco Bruno Borghesi
Date:
Subject: Re: Query question