PostgreSQL 查询窗口中使用变量查询数据，插入数据

--查询数据并赋值

 WITH brandid AS (
    SELECT
      id
    FROM brand
    WHERE code='bb'
)

--SELECT * FROM brandid;

--插入数据
insert into game(brand,game_code,attributes,category,supported_platform,create_at,update_at) 
SELECT id,'gamecode',0,'gamecatetory','platform',
'2023-07-24 12:24:51.477876','2023-07-24 12:24:51.477876'  FROM brandid;

--按赋值的条件查询数据

select * from game where brand=(select id from brandid);