Hi all I am coverting a database with several stored procedures from MS SQL Server to PostgreSQL 8.2 and I have the following doubt: With MS Sql a stored procedure containing the statement "SELECT * FROM TABLE_A INNER JOIN TABLE_B" automatically creates and return a recordset with all the fields of TABLE_A followed by all the fields of TABLE, instead, in my opinion, in a Postgresql function (language plpgsql) I MUST create by hand a type containing all the fields (or create BY hand a list in the declare space); The question is: It exist a method to create automatically the return type to avoid to write it by hand? Thank you. Domenico
