我将尝试在PostgreSQL函数中使用“WITH”语句,它是一种通用表达式。
以下是一个示例:
示例:
Create or replace function withFunction() returns void as
$Body$
Begin
WITH cmn_l1
AS
(
SELECT "PhoneNumber1","PhoneNumber2",
DENSE_RANK() OVER(Partition by "PhoneNumber1" Order By "PhoneNumber2" )FoundIn
From tablename;
)
SELECT DISTINCT * INTO temptable
FROM cmn_l1
WHERE FoundIn > 1;
end;
$Body$
language plpgsql;
问题: 如何使用函数内的WITH执行并获取上述表格中的值?
execute
用于动态 SQL,而perform
则用于不想返回 select 结果的情况。 - Clodoaldo Neto