Re: [HACKERS] multiple function execute using (func()).*

2008-12-09 Thread Merlin Moncure
On Mon, Dec 8, 2008 at 5:15 PM, Merlin Moncure [EMAIL PROTECTED] wrote: Hello, I've been bit by this about a million times: select (func()).* executes the function once per each field in the returned tuple. See the example below: create function foo_func() returns foo as $$ declare f

Re: [HACKERS] multiple function execute using (func()).*

2008-12-09 Thread Jeff
On Dec 8, 2008, at 5:15 PM, Merlin Moncure wrote: Hello, I've been bit by this about a million times: select (func()).* executes the function once per each field in the returned tuple. See the example below: I ran into this exact problem a week or two ago. I didn't dig too far into it

[HACKERS] multiple function execute using (func()).*

2008-12-08 Thread Merlin Moncure
Hello, I've been bit by this about a million times: select (func()).* executes the function once per each field in the returned tuple. See the example below: create function foo_func() returns foo as $$ declare f foo; begin raise notice '!'; return f; end; $$ language plpgsql;