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-----