Result Sets Conversion to PostgreSQL

As you know, PostgreSQL does not allow you to return resultsets directly from a procedure.
This can be a problem when migrating procedures from databases that support these mechanisms (SQL Server, Sybase ASE, etc.).
SQLWays (Beta) Web allows us to solve this problem and convert procedures that return resultsets in several ways.

Let's look at these methods using the example of converting a procedure from SQL Server to PostgreSQL.
This SQL Server procedure returns a resultset:

 create table test_data(c1 int, c2 varchar(22))
 create procedure result_set_pr @p1 Date as
 select @p1 as c0, c1, c2 from test_data

The option RETURN_RESULT_FROM_SP_AND_FN is responsible for the result of converting such procedures in our tool.
To change value for this option follow the instrations shown on the screenshot below:

If you have any questions or face any difficulties, please contact our support team: support@ispirer.com