Postgres Pro
Downloads
Home   >   mailing lists

Re: join removal - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: join removal
Date
Msg-id 4BB063FB.90901@cs.helsinki.fi
Whole thread Raw
In response to Re: join removal  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: join removal
List pgsql-hackers
Tree view 
On 2010-03-29 11:19 +0200, Pavel Stehule wrote:
> postgres=# explain select  a from a left join b on true;

This is effectively a cross join and it would give wrong answers.  Try
SELECT a FROM a LEFT JOIN b ON a.a = b.b;


Regards,
Marko Tiikkaja

pgsql-hackers by date:

Previous
From: Joachim Wieland
Date:
Subject: Re: five-key syscaches
Next
From: Pavel Stehule
Date:
Subject: Re: join removal