Re: select by streak

Richard Huxton wrote:
>
> From: "Joseph Shraibman" <jks(at)selectacast(dot)net>
>
> > Lets say I have a table like this:
> >
> > id int <== primary key
> > ts timestamp
> > name text
> > status char
> >
> > status is G for good or B for bad. How do I do something like:
> > SELECT name FROM mytable WHERE <last 3 entires in a row have status =
> > 'B'> and <has been no good ones in the past week> ?
>
> You're looking at a procedural solution here rather than SQL I'd suspect.
> Either do this in your application or look into plpgsql or pltcl.

That's what I was afraid of :(

--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com