James,
> but thats what:
> rec record
> select into rec id from table;
> return rec.id
>
> does
>
> my question was can i do this with a query built inside a string?
No. That's what I was talking about. You have to use the loop.
--
Josh Berkus
Aglio Database Solutions
San Francisco