HEX
Server: Apache/2.4.63 (Unix)
System: Linux Synopilou92 4.4.302+ #72806 SMP Mon Jul 21 23:16:00 CST 2025 x86_64
User: pilou92 (1026)
PHP: 8.0.30
Disabled: NONE
Upload Files
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
$$;