Hi Ivan,
If I have to know the column names then I can't use the Functions.
As I said before, the columns will vary. or As
Pavel Stehule said
I will use arrays.
Is anyone can show an example of returning a record with string and array?
Thanks,
Maria
On Tue, Jun 3, 2008 at 9:57 AM, Ivan Sergio Borgonovo <
mail@webthatworks.it> wrote:
On Tue, 3 Jun 2008 09:41:27 -0400
> Thanks for all your replies.
>
> Actually I don't know the number of columns that I am going to
> return.
>
> I have 2 tables. For a single entry E1 in one table(t1), I have
> to fetch all the matching entries for E1 from the other
> table(t2), K1,..Kn. and finally the function should return E1,
> K1..Kn. So I don't know the number of columns that I am going to
> get.
>
> Is it possible to write a function that returns this kind of
> result?
Up to my knowledge as Bart wrote in pl/pgsql you'll have to specify
somewhere the return type: in the function or in the select calling
the function.
If you use sql (not pl/pgsql) function you shouldn't be obliged to
specify the return type.
But I haven't written enough sql function to actually remember how
it works.
If you post your tentative sql it could give us more clue.
--