Excerpts from Heikki Linnakangas's message of jue ago 19 04:29:19 -0400 2010:
> While testing the recent issue with unknown params in EXECUTE USING, I 
> accidentally did this:
> 
> postgres=# DO $$
> DECLARE
>    t text;
> BEGIN
>    EXECUTE 'SELECT ''foo'' || $1' USING 'bar' INTO t;
>    RAISE NOTICE '%', t;
> END;
> $$;
> NOTICE:  <NULL>
> DO
> 
> The mistake I made? I put the USING and INTO clauses in wrong order, 
> INTO needs to go first. We should throw an error on that, but it looks 
> like the INTO clause is just silently ignored.

Can't we just accept either order?

-- 
Álvaro Herrera <alvhe...@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to