On 11/7/19 5:28 AM, İlyas Derse wrote:
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.
What version of Postgres?
So i did not find to solves this problem. Anybody have an idea ?
Start here: https://www.postgresql.org/docs/11/plpgsql-overview.html#PLPGSQL-ARGS-RESULTS https://www.postgresql.org/docs/11/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS https://www.postgresql.org/docs/11/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING If that does not help then post an example of what you are trying to do. -- Adrian Klaver adrian.klaver@xxxxxxxxxxx
