Re: Pl/Pgsql function troubles: FOLLOW UP

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Consider this:

DROP FUNCTION list_of_membership(INTEGER,TEXT);
CREATE FUNCTION list_of_membership(INTEGER,TEXT) RETURNS TEXT AS '
DECLARE
	membership_rec RECORD;
	membership TEXT;
BEGIN
	FOR membership_rec IN EXECUTE
		''SELECT name FROM org_details WHERE person_id = ''::text
		|| CAST($1 AS TEXT)
		|| '' AND type = ''::text
		|| quote_literal($2)
		|| '' ORDER BY name;'';
	LOOP
		IF membership IS NULL THEN
			membership := membership_rec.name;
		ELSE
			membership := membership
				|| '', ''::text
				|| membership_rec.name;
		END IF;
	END LOOP;
	RETURN membership;
END;
' LANGUAGE 'plpgsql' WITH (isstrict);


And here is how you want to be calling the function.
SELECT list_of_membership(1,'department');

Joshua b. Jore
http://www.greentechnologist.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8vWoHfexLsowstzcRAp26AJ4jqyb9Mk3VpPvpq3WMrhab4G2ceACg8ibr
R+ljghBHsTa5k9JFFuf6bNA=
=uUP3
-----END PGP SIGNATURE-----