On 2009-08-31, bilal ghayyad 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 pgsql-general mailing lis
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
bilal ghayyad 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
PL/pgSQL, you will ha
ginal Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org]
> On Behalf Of bilal ghayyad
> Sent: Monday, August 31, 2009 4:11 AM
> To: David Fetter
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Query and the number of
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/intera
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:
http://www.post
: 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 wrote:
> From: Da
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 wrote:
> From: David Fetter
> Subject: Re: [GENERAL] Query and the number of row result
> To: "bilal ghayyad
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 http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Postgresql.
Is there alot of Postgresql? How can I know mine?
Regards
Bilal
--- On Sun, 8/30/09, David Fetter wrote:
> From: David Fetter
> Subject: Re: [GENERAL] Query and the number of row result
> To: "bilal ghayyad"
> Cc: pgsql-general@postgresql.org
> Date: Su
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.
--
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:
http://www.postgresql.org/ma
12 matches
Mail list logo
