Mapping select results through a function

[jpat34721]

I want to apply a function to each of the values returned by another select statement.

i.e if my fuction delete_subtree takes an integer and performs an operation (in this case deleting a node from a tree view), I want to do (this doesn't work)

select delete_subtree(select node from tree where subject ~ 'poker'));

to delete all records whose subject contains the term poker.

What's the magic incantation?

[michaelb]

... ... ...
my fuction delete_subtree takes an integer and performs an operation ...
this doesn't work

select delete_subtree
  (select node from tree where subject ~ 'poker');
 

... ... ...

As you said, your function takes an integer, but looking at your subquery I suspect it may also return nothing or any number of rows.
See if you can work with the function that takes a varchar, so you can pass something like 'poker' and it'll do the rest.