2009/8/6 David Fetter <david@xxxxxxxxxx>: > 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@xxxxxxxxxx> http://fetter.org/ > Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter > Skype: davidfetter XMPP: david.fetter@xxxxxxxxx > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general