多列匹配更新
最近更新时间: 2025-02-18 16:02:00
postgres=# update tbase set ( nickname , age ) = ( 'TDSQL PG好' , (random()*2)::integer );
UPDATE 2
postgres=# select * from tbase;
id | nickname | age
----+-----------+-----
1 | TDSQL PG好 | 2
2 | TDSQL PG好 | 0
(2 rows)