Re: Problems with a Query between 7.3 and 8.2 - Mailing list pgsql-sql

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