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 bu

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 > $$ >

[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; po