Re: Migration to version 7.4

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Migration to version 7.4
Date: 2003-12-01 15:28:29
Message-ID: 3FCB5E1D.40707@e-trolley.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2003-12-01 15:53:46 Re: Migration to version 7.4
Previous Message Bruce Momjian 2003-12-01 15:08:55 Re: Migration to version 7.4