Re: SQL SERVER migration to PostgreSql

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