Re: [GENERAL] calling a function over several rows

2009-11-17 Thread Merlin Moncure
On Tue, Nov 17, 2009 at 1:35 AM, Adam Rich wrote: > Merlin Moncure wrote: >> >> On Tue, Nov 17, 2009 at 1:02 AM, Adam Rich wrote: >>> >>> Hello, >>> There is an existing function which takes an integer and returns a >>> record. >>>  I need to call this function with every integer in a table.  Is

Re: [GENERAL] calling a function over several rows

2009-11-16 Thread Adam Rich
Merlin Moncure wrote: On Tue, Nov 17, 2009 at 1:02 AM, Adam Rich wrote: Hello, There is an existing function which takes an integer and returns a record. I need to call this function with every integer in a table. Is there a simple shortcut for doing this? I'm looking for something like: se

Re: [GENERAL] calling a function over several rows

2009-11-16 Thread Pavel Stehule
2009/11/17 Adam Rich : > Hello, > There is an existing function which takes an integer and returns a record. >  I need to call this function with every integer in a table.  Is there a > simple shortcut for doing this? > > I'm looking for something like: > > select f.* > from function(t.value) f, ta

Re: [GENERAL] calling a function over several rows

2009-11-16 Thread Merlin Moncure
On Tue, Nov 17, 2009 at 1:02 AM, Adam Rich wrote: > Hello, > There is an existing function which takes an integer and returns a record. >  I need to call this function with every integer in a table.  Is there a > simple shortcut for doing this? > > I'm looking for something like: > > select f.* >

[GENERAL] calling a function over several rows

2009-11-16 Thread Adam Rich
Hello, There is an existing function which takes an integer and returns a record. I need to call this function with every integer in a table. Is there a simple shortcut for doing this? I'm looking for something like: select f.* from function(t.value) f, table t Thanks, Adam -- Sent vi