Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group