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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
