Re: Problems with a Query between 7.3 and 8.2

am Wed, dem 04.06.2008, um 12:47:41 +0200 mailte Holm Tiffe folgendes:
>
> Hi,
>
> I have to migrate an existing System from PostgreSQL 7 and 8.2.
> There is a query that I'm not fully understand. It is running with
> 7.3.21 generating two notices about missing FROM's:
>
> select poid,prodort.bez1 as prodort,sum(anz) as anz,
> art,bez1 from best_dat where type='P' and relid=best_hdr.relid
> and best_hdr.prod_date='20.04.2008' and poid=prodort.id
> group by poid,prodort.bez1,art,bez1
> order by poid,prodort.bez1,poid,art,bez1;
>
> NOTICE: Adding missing FROM-clause entry for table "prodort"
> NOTICE: Adding missing FROM-clause entry for table "best_hdr"

Add prodort and best_hdr to your FROM-clause in your query, this
behavior follows on the sql-spec.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net