Re: INOUT PARAMETERS WITH RETURN TABLES IN FUNCTION

On 11/8/19 12:18 AM, İlyas Derse wrote:
> I'm trying to migration to PostgreSql from SQL Server.  I have Stored 
> Procedures what have output parameters and return tables. How can i do 
> both together.

Can you show an example of a SQL Server procedure that demonstrates what 
you want to achieve?

> 
> Its like ;
> 
> CREATE or replace FUNCTION public."test" (INOUT "x" integer, INOUT "y" 
> character varying(36))
> 
> RETURNS TABLE  (
> "id" integer,
> "filesize" character varying(36)
> )
> AS $$
>   BEGIN
>    x=6;
> RETURN QUERY
> SELECT * FROM    public."tbl_employees" ;
> 
> END;
> $$ LANGUAGE plpgsql;
> 
> I can not create that because of inout parameters.
> Another place;
> 
> do $$
> DECLARE b integer = 1;
> DECLARE d integer = 2 ;
> BEGIN
>    select * from public."test"();
> END;
> $$;
> 
>   Anybody have an idea ?


-- 
Adrian Klaver
adrian.klaver@aklaver.com