Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: Joining two tables using *two* columns (instead of one) Date: Fri, 6 Apr 2012 01:00:09 +0000 (UTC) Organization: solani.org Lines: 15 Message-ID: References: <4f7d9c45$0$1745$426a34cc@news.free.fr> <4f7dc1f1$0$21932$426a74cc@news.free.fr> <9u6gdcF6d7U1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1333674009 21752 eJwFwYkRACEIBLCW1H1uKAc46b8EE8Hb/dEyNZoTQfhA7Qa3lFpMRsegCtG5sBC4denf8wD7eBBx (6 Apr 2012 01:00:09 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Fri, 6 Apr 2012 01:00:09 +0000 (UTC) User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-User-ID: eJwNwoERgDAIBMGWPhDOtBMQ+i9BdzacRT2bYMfEyFVL3AY72cGV5WmKVOeqAU/9p+KV2QcV8BEK Cancel-Lock: sha1:6f5G4uUfSg1RyeKhIXZNQKt++CM= X-NNTP-Posting-Host: eJwNx8kBwCAMA7CVgMROGac5vP8IrX6CcbPCCToErTzsXlkjMU8NdHtA62fbWzIQ+lcxnoj7AT10Ef4= Xref: csiph.com comp.databases.postgresql:336 On Thu, 05 Apr 2012 23:16:27 +0200, Robert Klemme wrote: > Did you look at the execution plan? What does it look like? > > Kind regards > > robert Robert, I don't understand? This looks like a syntax question, why is the plan important? Did I misunderstand anything here? -- http://mgogala.byethost5.com