| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Rob <rob(at)jamwarehouse(dot)com> |
| Cc: | pgNovice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Limiting the result set |
| Date: | 2002-08-16 12:40:22 |
| Message-ID: | 20020816124022.GA14620@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Fri, Aug 16, 2002 at 10:06:23 +0200,
Rob <rob(at)jamwarehouse(dot)com> wrote:
>
> Is there any way, IN ONE QUERY, to do this. So I want to basically return
> the first 500 results
> and a count of the total result set in one go. Is this possible?
>
> If not, what would be the quickest way to do this? The reason I need one
> query is because I use
> dynamic SQL, which complicates stuff a bit more
It is certainly possible to do this, if not efficient.
You can always just union two queries together using an extra column that
is null for the real records and returns the full count in a special
record. Order by can be used to make this record first or last.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Nelson | 2002-08-16 13:52:10 | Is my database done for? |
| Previous Message | Rob | 2002-08-16 08:06:23 | Limiting the result set |