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 r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
