File: /volume1/@appstore/SynologyPhotos/etc/sql/109.sql
CREATE OR REPLACE FUNCTION public.any_user_need_migrate_similar_hash ()
RETURNS boolean
LANGUAGE plpgsql
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 1
AS $$
BEGIN
RETURN EXISTS (
SELECT 1 FROM public.user_info
WHERE user_info.config ->> 'enable_similar' = 'true'
AND user_info.enable = 'true'
AND NOT EXISTS (
SELECT 1 FROM public.user_flag
WHERE user_info.id = user_flag.id_user
AND user_flag.flag = 'similar_hash_migration_done'
AND (user_flag.value = 'true' OR user_flag.value = 'error')
)
);
END
$$;