Re: How to call table returning function with other table

From: "Markus Bertheau" <mbertheau(dot)pg(at)googlemail(dot)com>
To: "Svenne Krap" <svenne(at)krap(dot)dk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to call table returning function with other table
Date: 2006-03-19 13:32:43
Message-ID: 684362e10603190532p1903fca8p@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

2006/3/19, Svenne Krap <svenne(at)krap(dot)dk>:

> So it is something like "select xxx(id) from othertable where otherwhere
> = 't'" except that it mangles the columns into an array. I have tried to
> move the function-call into the fromlist (as it is usually done) but I
> seem unsuccessful in getting the ID's into it.

You have to use something like SELECT (xxx(id)).* FROM othertable
WHERE otherwhere = 't', I believe.

Markus Bertheau

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Svenne Krap 2006-03-19 13:39:17 Re: How to call table returning function with other table
Previous Message Svenne Krap 2006-03-19 13:26:44 How to call table returning function with other table