On 11/24/2012 12:46 AM, Gavan Schneider wrote:
On Friday, November 23, 2012 at 21:36, Peter Kroon wrote:
Hello,
I wish to return the SELECT statement.
Ho can I achieve this?
DO $$
DECLARE v_some_id int=14;
BEGIN
/*
more queries here...
*/
SELECT 'this is text';
END
$$ LANGUAGE plpgsql;
Best,
Peter Kroon
Reinterpreting the question and taking the pseudocode semi-literally is
the following closer to what was asked?
The rub is that the OP wants to do this in a DO block which rules out
using RETURN.
Regards
Gavan
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
