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 <[EMAIL PROTECTED]> wrote: > On Tue, 3 Jun 2008 09:41:27 -0400 > "maria s" <[EMAIL PROTECTED]> 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >