首页 > 技术文章 > postgres 定义变量

qianxunman 2020-11-18 15:30 原文

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;

推荐阅读