From: Markus Bertheau <mbertheau.pg@googlemail.com>
To: Svenne Krap <svenne@krap.dk>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to call table returning function with other table
Date: Sun, 19 Mar 2006 19:32:43 +0600
Message-ID: <684362e10603190532p1903fca8p@mail.gmail.com> (raw)
In-Reply-To: <441D5C14.8010204@krap.dk>
References: <441D5C14.8010204@krap.dk>
2006/3/19, Svenne Krap <svenne@krap.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mbertheau.pg@googlemail.com, svenne@krap.dk
Subject: Re: How to call table returning function with other table
In-Reply-To: <684362e10603190532p1903fca8p@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox