Re: Out parameters handling

In fact, maybe a new option to set the OUT parameters prefix to use
from within the function body would do?

Le 7 mars 09 à 19:56, Dimitri Fontaine a écrit :
> CREATE OR REPLACE FUNCTION test_out
> (
>  IN  a integer,
>  IN  b integer,
>  OUT s integer
> )
> RETURNS setof integer
  SET out_prefix TO 'v_'

> LANGUAGE PLPGSQL
> AS $f$

Those two following lines would be deprecated:

> DECLARE
>  v_s ALIAS FOR $3;


> BEGIN
>  FOR v_s IN SELECT generate_series(a, b)
>  LOOP
>    v_s := v_s * v_s;
>    RETURN NEXT;
>  END LOOP;
>  RETURN;
> END;
> $f$;
>
> CREATE FUNCTION
> dim=# SELECT * FROM test_out(2, 4);
> s
> ----
>  4
>  9
> 16
> (3 rows)

--
dim