From: Svenne Krap <svenne@krap.dk>
To: Markus Bertheau <mbertheau.pg@googlemail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to call table returning function with other table
Date: Sun, 19 Mar 2006 14:39:17 +0100
Message-ID: <441D5F05.4060107@krap.dk> (raw)
In-Reply-To: <684362e10603190532p1903fca8p@mail.gmail.com>
References: <441D5C14.8010204@krap.dk>
<684362e10603190532p1903fca8p@mail.gmail.com>
Perfect. Thanks.
Svenne
Markus Bertheau wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
>
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) download
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: svenne@krap.dk, mbertheau.pg@googlemail.com
Subject: Re: How to call table returning function with other table
In-Reply-To: <441D5F05.4060107@krap.dk>
* 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