PL/pgsSQL EXECUTE USING INTO

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема PL/pgsSQL EXECUTE USING INTO
Дата
Msg-id 4C6CEB5F.4050004@enterprisedb.com
обсуждение исходный текст
Ответы Re: PL/pgsSQL EXECUTE USING INTO  (Robert Haas <robertmhaas@gmail.com>)
Re: PL/pgsSQL EXECUTE USING INTO  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: PL/pgsSQL EXECUTE USING INTO  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Coerce 'unknown' type parameters to the right type in the
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: git: uh-oh