| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | İlyas Derse <ilyasderse(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: SQL SERVER migration to PostgreSql |
| Date: | 2019-11-07 15:02:28 |
| Message-ID: | e118e8cb-5a11-78a9-4f32-ece965412eb1@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2019-11-07 15:02:48 | Re: logical replication - negative bitmapset member not allowed |
| Previous Message | Peter Eisentraut | 2019-11-07 15:02:21 | Re: logical replication - negative bitmapset member not allowed |