Postgres Pro
Downloads
Home   >   mailing lists

Returning number of matches on a query when using limit - Mailing list pgsql-general

From Mohamed
Subject Returning number of matches on a query when using limit
Date
Msg-id 861fed220901131256g4c7f728aoe613f62d50b0b133@mail.gmail.com
Whole thread Raw
Responses Re: Returning number of matches on a query when using limit
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Use PSQLFS for photo storage
Next
From: Reg Me Please
Date:
Subject: Re: Returning number of matches on a query when using limit