On 8/15/22 14:37, Perry Smith wrote:
Any comparative timing statistics on that? Especially on more than 73 records returned, because with that few just grab them all and get size() or length of what ever collection mechanism you're playing with.
On Aug 15, 2022, at 08:55, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Monday, August 15, 2022, Perry Smith <pedz@xxxxxxxxxxxxxxxx> wrote:I’ve been toying with row_number() and then sort by row_number descending and pick off the first row as the total number.
Use count as a window function.
I see others are commenting after David’s update so:
Thank you David.
This seems to work for me:
SELECT count(*) OVER (), id, basename, sha1 FROM dateien WHERE (lower(ext) in ( 'pxd' ) and ftype = 'file') ORDER BY sha1;
This has, e.g. 73, in the first column for all of the rows.
