Re: Query and the number of row result

I am talking in case I am writing a script for a function, and I need to know the number of the returned rows of the query, then I will do IF statement based on that number, how?

Regards
Bilal

--- On Mon, 8/31/09, Naoko Reeves <naoko(at)lawlogix(dot)com> wrote:

> From: Naoko Reeves <naoko(at)lawlogix(dot)com>
> Subject: RE: [GENERAL] Query and the number of row result
> To: "bilal ghayyad" <bilmar_gh(at)yahoo(dot)com>
> Cc: pgsql-general(at)postgresql(dot)org
> Date: Monday, August 31, 2009, 10:21 AM
> Which client do you use to access to
> db? GUI (pgAdmin?)? Command-line?
> Either way, it should give you row number...
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]
> On Behalf Of bilal ghayyad
> Sent: Monday, August 31, 2009 4:11 AM
> To: David Fetter
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Query and the number of row result
>
> Just writing a Function in the PostgreSQL it self (so it is
> sql scripting). It is not from any development language.
>
> Regards
> Bilal
>
> --- On Sun, 8/30/09, David Fetter <david(at)fetter(dot)org>
> wrote:
>
> > From: David Fetter <david(at)fetter(dot)org>
> > Subject: Re: [GENERAL] Query and the number of row
> result
> > To: "bilal ghayyad" <bilmar_gh(at)yahoo(dot)com>
> > Cc: pgsql-general(at)postgresql(dot)org
> > Date: Sunday, August 30, 2009, 10:41 PM
> > On Sun, Aug 30, 2009 at 07:35:42PM
> > -0700, bilal ghayyad wrote:
> > > Postgresql.
> > >
> > > Is there alot of Postgresql? How can I know
> mine?
> >
> > Are you connecting from C?  PHP?  Perl? 
> > Python?  Ruby?
> >
> > Cheers,
> > David.
> > --
> > David Fetter <david(at)fetter(dot)org>
> > http://fetter.org/
> > Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!:
> > dfetter
> > Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com
> >
> > Remember to vote!
> > Consider donating to Postgres: http://www.postgresql.org/about/donate
> >
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>