PL/pgsSQL EXECUTE USING INTO
| От | Heikki Linnakangas |
|---|---|
| Тема | PL/pgsSQL EXECUTE USING INTO |
| Дата | |
| Msg-id | 4C6CEB5F.4050004@enterprisedb.com обсуждение исходный текст |
| Ответы |
Re: PL/pgsSQL EXECUTE USING INTO
Re: PL/pgsSQL EXECUTE USING INTO Re: PL/pgsSQL EXECUTE USING INTO |
| Список | pgsql-hackers |
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. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: