automatic build of return type
От
dfx
Тема
automatic build of return type
Дата
Msg-id
000201c736fb$a8b45430$f400a8c0@SEMPRON
Список
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
В списке pgsql-general по дате отправления