Skip site navigation (1) Skip section navigation (2)

Re: What's the difference?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: vitus(at)ice(dot)ru
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: What's the difference?
Date: 2002-04-05 15:23:43
Message-ID: 24240.1018020223@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Victor Wagner <vitus(at)ice(dot)ru> writes:
> As far as I understand, following three queries are exactly equivalent:

Same results, but the second two constrain the planner's choice of join
order.  See

http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/explicit-joins.html

Whether this is a feature or a bug depends on context...

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Pierre-Alexis PaquinDate: 2002-04-08 14:42:18
Subject: Problem in Postgresql installation
Previous:From: Ron MayerDate: 2002-04-05 08:41:50
Subject: Re: Inconsistant use of index.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group