returning result sets from a function
i'm trying to create a function that will return a set of results. at the moment i can only see how to return a single value.
i've seen a type of 'SET' but the postgres documentation is pretty poor. some searches have suggested that it may not be possible which would be a shame, cos i just ditched mySQL cos i was sick of having certain features missing.
any links to good examples would be great.
July 11th, 2002, 07:14 PM
You can give interbase a go. It has stored procedure which you are looking for.
I am sorry that postgre does not have stored procs yet( I am not postgre guru so dont take my words granted)
Anyway you should search for interbase they went back to borland but there is a free version everywhere available.