使用列表作为参数进行 Select ，如果为空，则在PostgreSQL中不使用参数进行 Select

在你的where岁以下加上一个适当的条件:

SELECT Total, Total - Drinks AS "Without drinks", Drinks   
FROM (
  SELECT 
  SUM (f.prepared) 
  FILTER (
    WHERE f.date BETWEEN 'first' AND 'last'
    AND f.restaurant_id = ANY ('ids_arg')
  ) AS Total,
  SUM (f.prepared)
  FILTER (
    WHERE (f.product_id = 10 OR f.product_id = 17) 
    AND f.date BETWEEN 'first' AND 'last'
    AND f.restaurant_id = ANY ('ids_arg')
  ) AS Drinks
  FROM food f
  INNER JOIN tags t 
  ON t.restaurant_id = f.restaurant_id 
  WHERE array_position('tags_arg'::text[],t.name) IS NOT null 
     OR array_length('tags_arg'::text[],1) IS null
);

这也使它成为零安全的.无论您的t.name是否在tags_arg数组中，只要数组中也存在一个或多个null，或者t.name本身为空，或者两者兼而有之，都是一个常规的any(text[]) yields a null.这是因为any()使用正则相等=运算符，而array_position()使用is not distinct from构造.

这里有一张小抄:demo at db<>fiddle

select tags_arg,
       tags_arg::text[] as_array,
       'tag1'=any(tags_arg::text[])                                 as "base",
       'tag1'=any(coalesce(tags_arg::text[],array['tag1']::text[])) as "+coalesce()",
       'tag1'=any(coalesce(tags_arg::text[],array['tag1']::text[]))
            OR array_length(tags_arg::text[],1) is null             as "+coalesce()+OR",
       'tag1'=any(coalesce(tags_arg::text[],array['tag1']::text[]))
            OR array_length(tags_arg::text[],1) is null
            OR array_position(tags_arg::text[],null) is not null    as "+coalesce()+OR+nullsafe",
       array_position(tags_arg::text[],'tag1') is not null 
            OR array_length(tags_arg::text[],1) is null             as "final"
from (values  ('{tag1,tag2,tag3}') --matching array
             ,('{tag4,tag5}')      --non-matching array
             ,('{tag6,null}')      --non-matching with a null
             ,('{null}')           --only a null
             ,('{}')               --empty
             ,(null)              ) as args(tags_arg);