File: /volume1/@appstore/SynologyPhotos/etc/sql/45.sql
CREATE OR REPLACE FUNCTION public.display_shared_status_order (id_user integer, owner_id integer, enable boolean)
RETURNS integer
LANGUAGE plpgsql
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 1
AS $$
DECLARE
display_order integer;
BEGIN
-- shared, order 0
-- shared_with_me, order 1
-- not shared, order 2
IF (enable AND id_user = owner_id) THEN
display_order = 0;
ELSIF (enable AND id_user != owner_id) THEN
display_order = 1;
ELSE
display_order = 2;
END IF;
RETURN display_order;
END
$$;