On Saturday 26 May 2012, Raj Mathur (राज माथुर) wrote:
> On Friday 25 May 2012, Raj Mathur (राज माथुर) wrote:
> > On Thursday 24 May 2012, Elrich Marx wrote:
> > > If source changes, in this case from 1 to 2, then etime would be
> > > the last value of stime for source =1; So for source 1 it starts
On Friday 25 May 2012, Raj Mathur (राज माथुर) wrote:
> On Thursday 24 May 2012, Elrich Marx wrote:
> > If source changes, in this case from 1 to 2, then etime would be
> > the last value of stime for source =1; So for source 1 it starts
> > at stime 13:00 and continues till 13:02 (etime).
> >
> >
[email protected]
> Subject: Re: [SQL] Flatten table using timestamp and source
>
> On Thursday 24 May 2012, Elrich Marx wrote:
> > I am quite new to Postgres, so please bear with me.
> >
> > I have a table with data in the following format:
> >
> >
?
-Original Message-
From: [email protected] [mailto:[email protected]]
On Behalf Of Raj Mathur (??? ?)
Sent: 24 May 2012 01:59 PM
To: [email protected]
Subject: Re: [SQL] Flatten table using timestamp and source
On Thursday 24 May 2012, Elrich Marx wrote:
> I
On Thursday 24 May 2012, Elrich Marx wrote:
> I am quite new to Postgres, so please bear with me.
>
> I have a table with data in the following format:
>
> Table name : Time_Source_Table
>
> Source , Stime
> 1, "2012-05-24 13:00:00"
> 1, "2012-05-24 13:01:00"
> 1, "2012-05-24 13:02:00"
> 2, "20
Good day.
I am quite new to Postgres, so please bear with me.
I have a table with data in the following format:
Table name : Time_Source_Table
Source , Stime
1, "2012-05-24 13:00:00"
1, "2012-05-24 13:01:00"
1, "2012-05-24 13:02:00"
2, "2012-05-24 13:03:00"
2, "2012-05-24 13:04:00"
