proposal: plpgsql return execute ... - Mailing list pgsql-hackers

From Pavel Stehule
Subject proposal: plpgsql return execute ...
Date
Msg-id 162867790802270624td2146bcn41a89413cbbce016@mail.gmail.com
Whole thread Raw
Responses Re: proposal: plpgsql return execute ...  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Hello

I thing RETURN QUERY is successful idea. It should be completed with
support  of dynamic SQL.

Syntax:

RETURN EXECUTE sqlstring [USING];

This is shortcut for
FOR r IN EXECUTE sqlstring USING LOOP RETURN NEXT r;
END LOOP;

Regards
Pavel Stehule


pgsql-hackers by date:

Previous
From: cristianopintado@gmail.com
Date:
Subject: select avanced
Next
From: "Pavel Stehule"
Date:
Subject: Re: idea: simple variadic functions in SQL and PL/pgSQL