Re: [SQL] Multiple SRF parameters from query

2005-06-05 Thread Ramakrishnan Muralidharan
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 find out a solution for it. for set returning function the following link ma

Re: [SQL] Multiple SRF parameters from query

2005-06-04 Thread Michael Fuhr
On Sat, Jun 04, 2005 at 06:19:35PM +0200, Federico Pedemonte wrote: > > What i'm trying to do is a query where i get a result of this kind > > a | b | c > --+---+--- > 1 | 2 | 3 > 5 | 9 | 1 > 4 | 0 | 0 > 2 | 0 | 0 > 0 | 0 | 0 > > given that i select from the table Anagrafica the fields 'a

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