From: | "David E(dot) Wheeler" <david(at)justatheory(dot)com> |
---|---|
To: | pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | PL/pgSQL PERFORM with CTE |
Date: | 2013-08-20 12:04:08 |
Message-ID: | 91873FFA-838D-4A16-ABED-A0255ED5168F@justatheory.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hackers,
This seems reasonable:
david=# DO $$
david$# BEGIN
david$# WITH now AS (SELECT now())
david$# SELECT * from now;
david$# END;
david$# $$;
ERROR: query has no destination for result data
HINT: If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT: PL/pgSQL function inline_code_block line 3 at SQL statement
This not so much:
david=# DO $$
david$# BEGIN
david$# WITH now AS (SELECT now())
david$# PERFORM * from now;
david$# END;
david$# $$;
ERROR: syntax error at or near "PERFORM"
LINE 4: PERFORM * from now;
^
Parser bug in PL/pgSQL, perhaps?
Best,
David
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2013-08-20 12:11:52 | Re: PL/pgSQL PERFORM with CTE |
Previous Message | Boszormenyi Zoltan | 2013-08-20 09:47:55 | Re: Extension Templates S03E11 |