Postgres Pro
Downloads
Home   >   mailing lists

Re: JOIN a UNION - Mailing list pgsql-general

From David Fetter
Subject Re: JOIN a UNION
Date
Msg-id 20090806185140.GL4185@fetter.org
Whole thread Raw
In response to Re: JOIN a UNION  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: JOIN a UNION  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
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;

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: What happens when syslog gets blocked?
Next
From: Pavel Stehule
Date:
Subject: Re: JOIN a UNION