Re: Can I get the number of results plus the results with a single query?

From:	"David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To:	Perry Smith <pedz(at)easesoftware(dot)com>
Cc:	pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject:	Re: Can I get the number of results plus the results with a single query?
Date:	2022-08-15 13:55:17
Message-ID:	CAKFQuwYR-kmTsRJDQ-2US_KR1jvjORceUMsO5jv9duZBrtZqwg@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-08-15 13:49:33 from Perry Smith <pedz(at)easesoftware(dot)com>  2022-08-15 13:55:17 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>   2022-08-15 20:37:12 from Perry Smith <pedz(at)easesoftware(dot)com>    2022-08-15 22:13:49 from Rob Sargent <robjsargent(at)gmail(dot)com>     2022-08-16 09:15:14 from "Walter Dörwald " <walter(at)livinglogic(dot)de>      2022-08-16 09:58:52 from David Rowley <dgrowleyml(at)gmail(dot)com>  2022-08-15 18:16:18 from "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>   2022-08-15 19:20:44 from Bryn Llewellyn <bryn(at)yugabyte(dot)com>    2022-08-16 20:42:38 from "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>     2022-08-16 21:42:48 from Bryn Llewellyn <bryn(at)yugabyte(dot)com>      2022-08-17 09:26:34 from "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>  2022-08-22 07:17:09 from Wim Bertels <wim(dot)bertels(at)ucll(dot)be>
Lists:	pgsql-general

In response to

• Can I get the number of results plus the results with a single query? at 2022-08-15 13:49:33 from Perry Smith

Responses

• Re: ***SPAM*** Re: Can I get the number of results plus the results with a single query? at 2022-08-15 20:37:12 from Perry Smith

Browse pgsql-general by date

	From	Date	Subject
Next Message	jian he	2022-08-15 15:52:52	lateral join with union all
Previous Message	Perry Smith	2022-08-15 13:49:33	Can I get the number of results plus the results with a single query?