On Tuesday 13 January 2009 21:56:56 Mohamed wrote: > 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
... RETURNING COUNT(*) -- Fahrbahn ist ein graues Band weisse Streifen, grüner Rand -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
