Re: Migration to version 7.4 - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Migration to version 7.4
Date
Msg-id 3FCB5E1D.40707@e-trolley.de
Whole thread Raw
In response to Re: Migration to version 7.4  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Migration to version 7.4
Re: Migration to version 7.4
List pgsql-novice
Bruce Momjian wrote:
>>1) Inner joins using the explicit JOIN syntax may behave differently
>>because they are now better optimized.
>>
>>What exactly do you mean by 'may behave differently'?
>
>
> They will be fully optimized, so they might be faster.  In pre-7.4, ANSI
> syntax restricted the choices researched by the optimizer.

That's fine, but more important to me is if I need to change any queries in
my apps ;)

tfyh
--
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Migration to version 7.4
Next
From: Bruce Momjian
Date:
Subject: Re: Migration to version 7.4