Forum OpenACS Q&A: Response to order by at file-storage

Sorry that I spam you with this, but I have made some silly mistakes!!

This must be right now:

create function fs_connect_by(integer) returns text as '
declare
        id              alias for $1;
        pid             integer;
        title           varchar;
        folder          varchar;
BEGIN
        select parent_id, lower(file_title), folder_p INTO pid, title, folder from fs_files where id = file_id;
        IF pid is null
        THEN
                return folder || ''/'' || title || ''/'' || fs_gen_key(id);
        ELSE
                return fs_connect_by(pid) || ''/'' || folder || ''/'' || title || ''/'' || fs_gen_key(id);
        END IF;
END;
' language 'plpgsql';