pgpst 数组函数类型与数字类型比较

 

CREATE TEMPORARY TABLE tmp_emp_ids1 AS 
select array_agg(a.id order BY a.id) as "ids" from hr.hr_employee a
inner join hr.hr_employee_trans_record b on b.employee_id = a.id
where 
b.del_flag = '0'
and b.type='1'
and '2019-08-08' <= b.start_date::date

--图1

 

select * from hr.hr_employee 
where array[id]::bigint[] <@ (select ids from tmp_emp_ids1)

--图2