Postgres Pro
Downloads
Home   >   mailing lists

Re: Query and the number of row result - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Query and the number of row result
Date
Msg-id 200908310734.16016.aklaver@comcast.net
Whole thread Raw
In response to Re: Query and the number of row result  (bilal ghayyad <bilmar_gh@yahoo.com>)
List pgsql-general
Tree view 
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@comcast.net

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Query and the number of row result
Next
From: Kevin Kempter
Date:
Subject: print/return only the first X chars of a varchar column?