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@xxxxxxxxxxxx> wrote: > From: Naoko Reeves <naoko@xxxxxxxxxxxx> > Subject: RE: Query and the number of row result > To: "bilal ghayyad" <bilmar_gh@xxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] > On Behalf Of bilal ghayyad > Sent: Monday, August 31, 2009 4:11 AM > To: David Fetter > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxx> > wrote: > > > From: David Fetter <david@xxxxxxxxxx> > > Subject: Re: Query and the number of row > result > > To: "bilal ghayyad" <bilmar_gh@xxxxxxxxx> > > Cc: pgsql-general@xxxxxxxxxxxxxx > > 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@xxxxxxxxxx> > > http://fetter.org/ > > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: > > dfetter > > Skype: davidfetter XMPP: david.fetter@xxxxxxxxx > > > > Remember to vote! > > Consider donating to Postgres: http://www.postgresql.org/about/donate > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
