On 2009-08-31, bilal ghayyad bilmar...@yahoo.com wrote:
Just writing a Function in the PostgreSQL it self (so it is sql scripting).
It is not from any development language.
plpgsql or sql ?
plpgsql has GET DIAGNOSTICS:
GET DIAGNOSTICS integer_var = ROW_COUNT;
bye.
--
Sent via
On 31/08/2009 18:00, Tim Landscheidt wrote:
Presuming that you are talking about a function written in
PL/pgSQL, you will have to count them yourself or issue a
second query SELECT COUNT(*) FROM [...]. For the special
case that you want to find out whether no row at all was
found, you can
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 da...@fetter.org wrote:
From: David Fetter da...@fetter.org
Subject: Re: [GENERAL] Query and the number of row result
To: David Fetter
Cc: pgsql-general@postgresql.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 da...@fetter.org wrote
On Mon, Aug 31, 2009 at 04:10:48AM -0700, bilal ghayyad wrote:
Just writing a Function in the PostgreSQL it self (so it is sql
scripting). It is not from any development language.
You mean you're using plpgsql? If so then the plpgsql docs are
available here and should help:
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:
Subject: RE: [GENERAL] Query and the number of row result
To: bilal ghayyad bilmar...@yahoo.com
Cc: pgsql-general@postgresql.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
bilal ghayyad bilmar...@yahoo.com wrote:
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?
[...]
Presuming that you are talking about a function written in
Hi All;
After doing a SELECT query, how can I know the number of returned rows from
this query? If it returned 5 rows or 1 row or non?
Regards
Bilal
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Sun, Aug 30, 2009 at 06:56:59PM -0700, bilal ghayyad wrote:
Hi All;
After doing a SELECT query, how can I know the number of returned
rows from this query? If it returned 5 rows or 1 row or non?
Lots of language bindings have this. Which language(s) are you using?
Cheers,
David.
--
Postgresql.
Is there alot of Postgresql? How can I know mine?
Regards
Bilal
--- On Sun, 8/30/09, David Fetter da...@fetter.org wrote:
From: David Fetter da...@fetter.org
Subject: Re: [GENERAL] Query and the number of row result
To: bilal ghayyad bilmar...@yahoo.com
Cc: pgsql-general
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 da...@fetter.org http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666
12 matches
Mail list logo