Ashley Moran <work@ashleymoran.me.uk> 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°
