Is there anyway to return a recordset from a Stored Procedure in Postgres so that it
can be used as a type of view or select?
I know that you can do this in Interbase or MS-SQL.
I have seen that you can return a complete record but that's not really the same thing.
Marc Rohloff
>> select a.col1, b.col2 from a,b
>> where a.col1 = b.col2
>>or a.col1 not in (select b.col2 from b)
>This would work, but it would be *much* slower than a UNION query. "Not
>In" queries are perhaps the slowest you can run; see the earlier thread
>"Query Problem" for a discussion. UNION qu
.col2
or a.col1 not in (select b.col2 from b)
These would seem to be far more efficient than a union query
(I would try this but I don't have a Unix box at the moment to install PostgreSQL on!)
Marc Rohloff
