I'm moving to PostgreSQL from MS SQL Server. In MSSQL I usually create
stored procedures to return result sets based on the passed arguments.
I guess my question is: Is it possible to return multi-row data from
the PL/PGSQL functions of Postgres? It's rather easy to just return
one field for a particular row. I've played with the RECORD datatype
but it seems you can't return it from a function.
TIA,
Ryan Roemmich