bug in integration SQL parser to plpgsq
| От | Pavel Stehule |
|---|---|
| Тема | bug in integration SQL parser to plpgsq |
| Дата | |
| Msg-id | 162867791001120210j7db534e1tf45eff7a1f61af66@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: bug in integration SQL parser to plpgsq
Re: bug in integration SQL parser to plpgsq |
| Список | pgsql-hackers |
Hello it doesn't support EXPLAIN as possible begin of SQL statement: postgres=# create or replace function foo(_a int) returns void as $$declare s varchar; begin for s in explain select * from omega where a = _a loop raise notice '%', s; end loop; return; end; $$ language plpgsql; CREATE FUNCTION postgres=# select foo(10); ERROR: column "_a" does not exist CONTEXT: PL/pgSQL function "foo" line 1 at FOR over SELECT rows postgres=# create or replace function foo(_a int) returns void as $$declare s varchar; begin for s in select * from omega where a = _a loop raise notice '%', s; end loop; return; end; $$ language plpgsql; CREATE FUNCTION postgres=# select foo(10);foo ----- (1 row) Regards Pavel Stehule
В списке pgsql-hackers по дате отправления: