İlyas Derse schrieb am 07.11.2019 um 14:28:
> I'm trying to migration to PostgreSql from SQL Server. I have Stored
> Procedures what have output parameters and returning tables.But you
> know what, we can not returning tables in stored procedures in
> PostgreSql and we can not use output parameters in functions in
> PostgreSql.
The correct migration path is to rewrite them to set-returning functions and use them in the FROM clause:
so instead of
sp_foobar 42;
use
select *
from fn_foobar(42);
Thomas
