I am having to convert a MS SQL Stored Procedure to a Postgresql Function.
I have a MS SQL Stored Procedure that has an Output Paramter aswell as Returning Columns in a table. I have looked in the Postgresql documentation and it talks about both of these but not using them together. I have tried a few things but have had no luck I'm thinking that it will involve the "RETURN NEXT" statement. Anyways here is the code for the MS SQL Stored Procedure. If anyone has any ideas please share.
CREATE PROCEDURE dbo.sp_GetCountries
@ListFirst int OUTPUT
SET @ListFirst =
COUNT(CountryID) AS Expr1
(ListFirst = 1))
Hi Shammat thanks for the reply.
I don't have access to the code at the moment however to my knowledge what this is doing is selecting from a list of countries and setting which country appears first in the list. I'm still not clear as to whether or not returning an output parameter and a table is possible?