ql.org
Subject: [SQL] Multiple SRF parameters from query
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
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
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
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
