Search Postgresql Archives
Returning number of matches on a query when using limit
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
:
pgsql-general@xxxxxxxxxxxxxx
Subject
: Returning number of matches on a query when using limit
From
: Mohamed <
mohamed5432154321@xxxxxxxxx
>
Date
: Tue, 13 Jan 2009 21:56:56 +0100
Hi. How would I return the number of matches found by a query, but when I only want to return 30 of them ?
In MySQL there is a way of calling SQL_CALC_FOUND_ROWS to do this?
Is there something similiar that can be done in PostgreSQL ? Do I have to rerun my query?
Thanks / Moe
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Returning number of matches on a query when using limit
From:
Reg Me Please
Prev by Date:
Re: Use PSQLFS for photo storage
Next by Date:
Re: Returning number of matches on a query when using limit
Previous by thread:
XPath to search for elements in a sequence
Next by thread:
Re: Returning number of matches on a query when using limit
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]