Re: Variable assignment from dynamic SQL in PL/PgSQL
От | Robert Treat |
---|---|
Тема | Re: Variable assignment from dynamic SQL in PL/PgSQL |
Дата | |
Msg-id | 1095873549.14485.58.camel@camel обсуждение исходный текст |
Ответ на | Variable assignment from dynamic SQL in PL/PgSQL (David Fetter <david@fetter.org>) |
Список | pgsql-hackers |
On Tue, 2004-09-21 at 23:28, David Fetter wrote: > Kind people, > > I've figured out something that many others probably have, but I > thought I'd put it out there anyhow. > > As PL/PgSQL doesn't allow assignment of singleton SELECTs and dynamic > queries to variables, as mentioned in the docs. > > Here's a working hack that gets around this. > > DECLARE foo_rec RECORD; > BEGIN > FOR foo_rec IN EXECUTE -- put together a singleton sql function here. > LOOP > END LOOP; > -- do stuff with foo_rec.bar, foo_rec.baz, &c. > END; > > Should this hack turn into a TODO item? If so, what problems should > get addressed? Features added? Is PL/PgSQL in such shape as it needs > a big overhaul? > I believe this to be addressed already in 8.0, though I haven't had time to confirm this... maybe you want to try it out on the beta release. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
В списке pgsql-hackers по дате отправления: