[SQL] Multiple SRF parameters from query

2005-05-31 Thread Federico Pedemonte
Hi All, i'm having troubles trying to write a sql query using a Set Returning Function. I have a function foo (ID varchar) that returns a variable number of records. I have also a table (called Anagrafica) that contains a list of IDs to be passed to the function foo. As an example, just say that

Re: [SQL] Multiple SRF parameters from query

2005-06-04 Thread Federico Pedemonte
On Wed, 2005-06-01 at 10:29 +0530, Ramakrishnan Muralidharan wrote: > Hi, > > I am not able to understand "Returning only one row", since 'aaa' having 2 > rows and 'bbb' having 3 rows and what criteria single row should be returned. > Please let me know the expected result and I will try to fi