Subject: Any way to handle exceptions in PL/pgSQL ?
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Date: Sat, 1 Jun 2002 00:11:44 -0400
Content-Transfer-Encoding: quoted-printable
Message-ID: <6E2C6F49B3E09548A38EDCAD31C4182F04DDA0@MAIN.compiere.org>
content-class: urn:content-classes:message
Thread-Topic: Any way to handle exceptions in PL/pgSQL ?
Thread-Index: AcIJInC0QjDPAakFTeeyDEQ5dphaOQ==
From: "Jorg Janke" <jorg.janke@compiere.org>
To: <pgsql-sql@postgresql.org>

Is there any way to handle failed queries in PL/pgSQL?

<< I am aware that the example can be re-worded in a single query; This
is a question more on how to do the 'procedural' part >>

Example:
	1st query
	if OK, return result
	2ne query
	if OK, return result
	return error message

Is it correct, that if a function fails, it returns null ??


-- Function: message_get(varchar)
CREATE FUNCTION message_get(varchar) RETURNS varchar AS '
DECLARE
	p_key ALIAS FOR $1;
	v_RetValue Message.MsgText%TYPE;
BEGIN
	SELECT MsgText INTO v_RetValue=20
	FROM User_Message=20
	WHERE Value =3D p_Value;
	-- if ok ??
	RETURN v_RetValue;

	SELECT Text INTO v_RetValue=20
	FROM Sys_Message
	WHERE Value =3D p_Value;
	-- if ok ??
	RETURN v_RetValue;

	RETURN 'nothing found';
END;
' LANGUAGE 'plpgsql';

Cheers,

Jorg Janke      (203) 445-9503                   http://www.compiere.org
Smart ERP & CRM Business Solution for Distribution and Service  globally
------------------------------------------------------------------------
General questions/issues:   http://sourceforge.net/forum/?group_id=3D29057
Support via:  http://sourceforge.net/tracker/?group_id=3D29057&atid=3D410216
------------------------------------------------------------------------