Skip site navigation (1) Skip section navigation (2)

need help on stored procedures

From: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: need help on stored procedures
Date: 2004-07-07 10:13:00
Message-ID: 77ED2BF75D59D1439F90412CC5B109740E8C056A@ie10-sahara.hiso.honeywell.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi all,

I have written a sample procedure where i pass 2 arguments. Based on the
arguments i need to select few fields from a table. After selecting the
fields i have to display them. How do i return the selected fields. The
procedure is as follows

CREATE FUNCTION PP_ReadParameter(integer,varchar) RETURNS TEXT AS '
DECLARE
	ParamId INTEGER;
	ParamName TEXT;
	IsFixEnum BIT;
	IsExpandEnum BIT;
BEGIN
	IF $1 IS NOT NULL THEN
		SELECT INTO ParamId,ParamName,IsFixEnum,IsExpandEnum
AttributeId,AttributeName,IsFixEnum,IsExpandEnum
		FROM Attributes
		WHERE AttributeId = $1
		ORDER BY AttributeId;

		RETURN ''$1 successfull'';
	END IF;
	......
	......
END;
' LANGUAGE 'plpgsql';

So when i say SELECT PP_ReadParameter(50,Null)......it should return the
ParamId,ParamName,....
But to check the working of the function i just return ''$1 successfull'' as
i dont know how to return the tuple.

Please help me on this


> With Best Regards 
> Pradeep Kumar P J 
> 

pgsql-novice by date

Next:From: David.VentimigliaDate: 2004-07-07 20:01:28
Subject: table inheritance and polymorphic functions
Previous:From: Mel JameroDate: 2004-07-07 06:15:43
Subject: Re: JDBC or ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group