Re: Using Function returning setof record in JOIN

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql(dot)general(at)googlegroups(dot)com, gmb <gmbouwer(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Using Function returning setof record in JOIN
Date: 2011-04-08 14:56:53
Message-ID: BANLkTim5burO32+LRrDUU4TwuWYuWQXZTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2011/4/8 Merlin Moncure <mmoncure(at)gmail(dot)com>:
> On Fri, Apr 8, 2011 at 5:57 AM, gmb <gmbouwer(at)gmail(dot)com> wrote:
>> Hi
>>
>> Is it possible to do a JOIN between a VIEW and the output of a FUNCTION?
>
> yes.

yes, it is possible. Just I am not sure if original query wasn't
directed to >>lateral<< feature.

Pavel

>
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shianmiin 2011-04-08 15:03:36 Re: PostgreSQL backend process high memory usage issue
Previous Message Andrew Sullivan 2011-04-08 14:56:28 Re: why autocommit mode is slow?