can i declare function with return type RECORD in PostgreSQL 7.4.13? I tried it but it doesn't seem to be working. When i try to create the function in pgAdmin a return type of RECORD is not available in the drop-down menu for picking a function return type. And when i try to create it in psql it gave me an error.
Is this possible at all in my version of PostgreSQL or not?
If i can not use a RECORD as the return type of a function what else can I do to make my function return the result of SELECT sql query? Let's say I have a SQL query that queries multiple tables and returns a large number of records. How can I make a PostgreSQL function that returns the results from the query?
Btw, this is for use in a CrystalReport.NET. I am using Visual Studio 2005 and my application is in VB.NET.