Polymorphic "setof record" function?
От | Christian Schröder |
---|---|
Тема | Polymorphic "setof record" function? |
Дата | |
Msg-id | 496C9C39.40403@deriva.de обсуждение исходный текст |
Ответы |
Re: Polymorphic "setof record" function?
Re: Polymorphic "setof record" function? Re: Polymorphic "setof record" function? |
Список | pgsql-general |
Hi list, I have written a function that returns a setof record. The function has a table name as a parameter and the resulting records have the same structure as this table. Is there any easy way to specify this when I call the function? If the table has many columns then it's annoying to specify all of them. I need something like: select * from myfunc('mytable') as x(like mytable) or select * from myfunc('mytable') as x(mytable%TYPE) Is there any solution for PostgreSQL 8.2? Regards, Christian -- Deriva GmbH Tel.: +49 551 489500-42 Financial IT and Consulting Fax: +49 551 489500-91 Hans-Böckler-Straße 2 http://www.deriva.de D-37079 Göttingen Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer
В списке pgsql-general по дате отправления: