且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

插入(如果不存在)并返回ID

更新时间:2023-10-10 22:49:04

with i as (
    INSERT INTO t(a) VALUES ('a') ON CONFLICT (a) DO NOTHING RETURNING id
)
select id from i
union all
select id from t where a = 'a'
limit 1