/ Published in: SQL
Convert an oid value into a bytea value.
Expand |
Embed | Plain Text
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;
You need to login to post a comment.
