Postgres Pro
Downloads
Home   >   mailing lists

Re: Check if there 6 last records of same type without gaps - Mailing list pgsql-general

From Alexander Farber
Subject Re: Check if there 6 last records of same type without gaps
Date
Msg-id CAADeyWgJgvtR_Sg0gt7bjQTAtE+YhhVQQocU9QQTR7uuBbm2aA@mail.gmail.com
Whole thread Raw
In response to Re: Check if there 6 last records of same type without gaps  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view
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)

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgadmin4 rc1 query tool performance
Next
From: Sándor Daku
Date:
Subject: Re: Check if there 6 last records of same type without gaps