Ashley Moran <work@xxxxxxxxxxxxxxxxx> schrieb: > > On Mar 14, 2007, at 6:02 pm, Andreas Kretschmer wrote: > >select * from <insert_your_srf-function_here>. > >For instance, if your SRF-function is called foo(), do: > >select * from foo(); > > > Andreas, > > It's more complicated than that. What we need to do is something along > the lines of: > > results = SELECT * FROM foo(); Try something like: create results as SELECT * FROM foo(); Than you can do: > DELETE FROM results WHERE (some condition involving results); > some_value = SELECT value FROM results WHERE (etc); Try: create table some_value as SELECT value FROM results WHERE (etc); > > and so on... Yes, and so on... > > All of which is easy with table variable, but I can't see how to translate > it to PL/pgsql. Is there any way to manipulate result sets in a set-based > manner like this? You can do a lot in pl/pgsql. For some things, for instance dynamically created SQLs, you need EXECUTE. But you can do a lot with pl/pgsql. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
