Revision: 54893
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at January 16, 2012 17:45 by arunpjohny
Initial Code
CREATE OR REPLACE FUNCTION merge_oid(val oid) returns bytea as $$ declare merged bytea; declare arr bytea; BEGIN FOR arr IN SELECT data from pg_largeobject WHERE loid = val ORDER BY pageno LOOP IF merged IS NULL THEN merged := arr; ELSE merged := merged || arr; END IF; END LOOP; RETURN merged; END $$ LANGUAGE plpgsql;
Initial URL
Initial Description
Convert an oid value into a bytea value.
Initial Title
Convert OID to Bytea
Initial Tags
Initial Language
SQL