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

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Check if there 6 last records of same type without gaps
Date: 2016-09-06 13:32:34
Message-ID: CAADeyWgJgvtR_Sg0gt7bjQTAtE+YhhVQQocU9QQTR7uuBbm2aA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Also tried the second suggestion:

words=> select count(action='skip') from words_moves where gid=3 group by
played order by played desc limit 6;
count
-------
1
1
1
1
1
1
(6 rows)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sándor Daku 2016-09-06 13:35:45 Re: Check if there 6 last records of same type without gaps
Previous Message Adrian Klaver 2016-09-06 13:23:26 Re: pgadmin4 rc1 query tool performance