PostgreSQL数组实现多字段拼接、传入多条件查询
select *
from tzq_bas_date_rule_head_t
where date_rule_head_id in (
select tmp.s1
from (select distinct unnest(ARRAY[r.date_rule_head_id,r.twice_salary_date_rule_head_id ]) as
select *
from tzq_bas_date_rule_head_t
where date_rule_head_id in (
select tmp.s1
from (select distinct unnest(ARRAY[r.date_rule_head_id,r.twice_salary_date_rule_head_id ]) as