Re: JOIN a UNION

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: "david(dot)schruth" <dschruth(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: JOIN a UNION
Date: 2009-08-06 18:52:40
Message-ID: 162867790908061152y331899ei3caffee86dde71a3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/8/6 David Fetter <david(at)fetter(dot)org>:
> On Thu, Aug 06, 2009 at 08:33:57PM +0200, Pavel Stehule wrote:
>> Hello
>>
>> SELECT ... FROM
>>   (SELECT ... FROM A
>>    UNION ALL
>>    SELECT FROM B) s1
>>  JOIN C IN C.z = s1.z;
>
> That last line should read:
>
>    JOIN C ON C.z = s1.z;

I am sorry

Pavel
>
> Cheers,
> David.
> --
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
> Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2009-08-06 19:00:37 Re: What happens when syslog gets blocked?
Previous Message David Fetter 2009-08-06 18:51:40 Re: JOIN a UNION