DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=e1W4QlmlSUZCog9uaeYrBrKCBCke6zpvQVjdCpaFeTM8+V1I+VyNYKChS+Su7Dki/F
	iJ5DAmW0KXUuF/38p42hhZPjPfHgBd0lZIkB565rKAiN4ScHzX3niw5/p/4Arxd6/N6z
	hhAYjdAduPv4XspX8ECpzXONeoeD22sTfbEoU=
MIME-Version: 1.0
In-Reply-To: <675038.56213.qm@web53902.mail.re2.yahoo.com>
References: <675038.56213.qm@web53902.mail.re2.yahoo.com>
Date: Tue, 1 Sep 2009 07:35:53 +0200
Message-ID: <162867790908312235t232a86d8sbeded1c02b62ae92@mail.gmail.com>
Subject: Re: PostgreSQL Function: how to know the number of the returned
	results of the Query
From: Pavel Stehule <pavel.stehule@gmail.com>
To: bilal ghayyad <bilmar_gh@yahoo.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello

look on PERFORM and GET DIAGNOSTICS statements

http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-S=
TATEMENTS-SQL-NORESULT
http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-S=
TATEMENTS-DIAGNOSTICS

regards
Pavel Stehule

2009/9/1 bilal ghayyad <bilmar_gh@yahoo.com>:
> Hi List;
>
> I am building a function in the SQL (PostgreSQL), so I will be able to ca=
ll this function using a SELECT query. Inside the body of this function, I =
was need to do the following but not able to know how:
>
> I have a SELECT statement (inside the function script itself), and I need=
 to know the number of the returned rows of that select query, if it is one=
 row or 2 or 3 , ... How? In which paramter I will be able to check this?
>
> For example, I have the following function:
>
> CREATE OR REPLACE FUNCTION get_credit_time(text, text)
> =C2=A0RETURNS integer AS
> $BODY$
> DECLARE
> BEGIN
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 rate numberic(9,4);
> =C2=A0 =C2=A0 =C2=A0 =C2=A0SELECT rate from voiptariff where id=3D 9;
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 IF num_rows =3D=3D1 THEN =C2=A0 -- As example=
, but I am asking how to do it?
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 .............
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 ELSE
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 .............
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 END IF
> END
> $BODY$
> =C2=A0LANGUAGE 'sql' IMMUTABLE
> =C2=A0COST 100;
> ALTER FUNCTION get_bool(text) OWNER TO gkradius;
>
> In this function, I need to check the number of returned rows of the stat=
ement: SELECT rate from voiptariff where id=3D 9; because based on it I am =
going to build if statment, How?
>
> Any help?
>
> Regards
> Bilal
>
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>