postgres 定义变量

https://www.itranslater.com/qa/details/2127214981010686976

WITH myconstants (var1, var2) as (
   values (5, 'foo')
)
-- select var1,var2;

SELECT *
FROM stock_move, myconstants
WHERE picking_id = var1
   OR name = var2;
posted @ 2020-11-18 15:30  那时一个人  阅读(2603)  评论(0编辑  收藏  举报