Skip site navigation (1) Skip section navigation (2)

Re: function returning result set of varying column

From: "maria s" <psmg01(at)gmail(dot)com>
To: "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: function returning result set of varying column
Date: 2008-06-03 14:06:45
Message-ID: d9d42a0f0806030706w3f6a724ble8bd964885099c3b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)webthatworks(dot)it>
wrote:

> On Tue, 3 Jun 2008 09:41:27 -0400
> "maria s" <psmg01(at)gmail(dot)com> wrote:
>
> > 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.
>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

In response to

Responses

pgsql-sql by date

Next:From: Pavel StehuleDate: 2008-06-03 14:13:28
Subject: Re: function returning result set of varying column
Previous:From: Paul DamDate: 2008-06-03 14:02:51
Subject: Re: cross-database references are not implemented

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group