folder_and_subfolders
----- Recursive bulk updates! CREATE OR REPLACE FUNCTION folder_and_subfolders(INT) RETURNS SETOF INT AS ' DECLARE ident record; ident2 record; BEGIN RETURN NEXT $1; FOR ident IN SELECT identifier FROM folder f WHERE f.parent_folder = $1 LOOP FOR ident2 IN SELECT * FROM folder_and_subfolders(ident.identifier) LOOP RETURN NEXT ident2.folder_and_subfolders; END LOOP; END LOOP; RETURN; END; ' LANGUAGE 'plpgsql';
Version 2.34
Still in use
= Version 2.34 =
----- Recursive bulk updates! CREATE OR REPLACE FUNCTION folder_and_subfolders(INT) RETURNS SETOF INT AS ' DECLARE ident record; ident2 record; BEGIN RETURN NEXT $1; FOR ident IN SELECT identifier FROM folder f WHERE f.parent_folder = $1 LOOP FOR ident2 IN SELECT * FROM folder_and_subfolders(ident.identifier) LOOP RETURN NEXT ident2.folder_and_subfolders; END LOOP; END LOOP; RETURN; END; ' LANGUAGE 'plpgsql';