夏至

create table A(
packid jsonb
);

create table B(
packid varchar(64)
);
insert into aimb.A values('["1","2"]');

insert into aimb.B values('2');

select * from A
select * from B
select json_each(packid) from aimb.A
select ta.packid as Ap, tb.packid as Bp from
(select jsonb_array_elements_text(packid) as packid from aimb.A) ta
left join aimb.B tb on ta.packid = tb.packid

select tb.packid from
aimb.A ta
, aimb.B tb where ta.packid @> ('["' || tb.packid || '"]')::jsonb

两个人？情侣？

emmmm

推荐一部我特喜欢的 if i stay

👍 谢谢了

总感觉无从下手，如果要改起码要花很多时间看懂

好的

放到 tomcat9 就没问题了

本地这个发帖要等很久嘛？点击发帖没反应