Re: [GENERAL] Polymorphic setof record function?

2009-01-15 Thread Christian Schröder
Merlin Moncure wrote: On 1/13/09, Christian Schröder c...@deriva.de wrote: 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

Re: [GENERAL] Polymorphic setof record function?

2009-01-15 Thread Merlin Moncure
On Thu, Jan 15, 2009 at 4:57 AM, Christian Schröder c...@deriva.de wrote: Merlin Moncure wrote: 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?

Re: [GENERAL] Polymorphic setof record function?

2009-01-14 Thread Merlin Moncure
On 1/13/09, Christian Schröder c...@deriva.de wrote: 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?

Re: [GENERAL] Polymorphic setof record function?

2009-01-14 Thread Ivan Sergio Borgonovo
On Wed, 14 Jan 2009 11:46:29 -0500 Merlin Moncure mmonc...@gmail.com wrote: On 1/13/09, Christian Schröder c...@deriva.de wrote: 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

[GENERAL] Polymorphic setof record function?

2009-01-13 Thread Christian Schröder
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

Re: [GENERAL] Polymorphic setof record function?

2009-01-13 Thread Emanuel Calvo Franco
2009/1/13 Christian Schröder c...@deriva.de: 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

Re: [GENERAL] Polymorphic setof record function?

2009-01-13 Thread Sam Mason
On Tue, Jan 13, 2009 at 02:50:49PM +0100, Christian Schrrrder wrote: 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