WITH myconstants (var1, var2) as (
values (5, 'foo')
)
-- select var1,var2;
SELECT *
FROM stock_move, myconstants
WHERE picking_id = var1
OR name = var2;
postgres 定义变量
懂得,原来世界如此简单!
qianxunman 2020-11-18 15:30 原文
WITH myconstants (var1, var2) as (
values (5, 'foo')
)
-- select var1,var2;
SELECT *
FROM stock_move, myconstants
WHERE picking_id = var1
OR name = var2;
懂得,原来世界如此简单!