Re: Query and the number of row result

On 31/08/2009 18:00, Tim Landscheidt wrote:

> Presuming that you are talking about a function written in
> PL/pgSQL, you will have to count them yourself or issue a
> second query "SELECT COUNT(*) FROM [...]". For the special
> case that you want to find out whether no row at all was
> found, you can look at "IF (NOT) FOUND".

In pl/pgsql you can also issue a GET DIAGNOSTICS command which gets the
row count:

http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

...although it is still has to be done as a second query, as in your
suggestions above.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------