Re: Check if there 6 last records of same type without gaps

Sandor, this has worked, thank you -

On Tue, Sep 6, 2016 at 3:35 PM, Sándor Daku <daku(dot)sandor(at)gmail(dot)com> wrote:

>
> Of course you need the played field you relied on it in the order by
> clause. You can use the result of a select in a from clause of another
> select.
>
> SELECT SUM(skips) from (SELECT CASE WHEN action='skip' THEN 1 ELSE 0 END
> as skips, played
> FROM words_moves
> WHERE gid = 3
> ORDER BY played DESC
> LIMIT 6) as skipscount;
>
>
words=> SELECT SUM(skips) from (SELECT CASE WHEN action='skip' THEN 1 ELSE
0 END as skips, played
words(> FROM words_moves
words(> WHERE gid = 3
words(> ORDER BY played DESC
words(> LIMIT 6) as skipscount;
sum
-----
6
(1 row)