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@aklaver.com
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных