Re: Query and the number of row result

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: bilal ghayyad <bilmar_gh(at)yahoo(dot)com>, David Fetter <david(at)fetter(dot)org>
Subject: Re: Query and the number of row result
Date: 2009-08-31 14:34:15
Message-ID: 200908310734.16016.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 31 August 2009 4:10:48 am bilal ghayyad wrote:
> Just writing a Function in the PostgreSQL it self (so it is sql scripting).
> It is not from any development language.
>
> Regards
> Bilal
>

If you move to pl/pgsql you could use GET DIAGNOSTICS:
(http://www.postgresql.org/docs/8.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS)
It has ROW_COUNT.

--
Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Kempter 2009-08-31 14:49:12 print/return only the first X chars of a varchar column?
Previous Message Sam Mason 2009-08-31 14:31:43 Re: Query and the number of row result