What's it: NOTICE: Adding missing FROM-clause entry - Mailing list pgsql-general

From Vitaliy V. Romanets
Subject What's it: NOTICE: Adding missing FROM-clause entry
Date
Msg-id Pine.LNX.4.10.10106251652570.337-100000@raven.gu.net
Whole thread Raw
Responses Re: What's it: NOTICE: Adding missing FROM-clause entry  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: What's it: NOTICE: Adding missing FROM-clause entry  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Hi All!  :)
There are two tables:
test(a int4,b varchar(20));
test2(c int4,d varchar(20));
I do the following:
 select a,b,test2.d from test where a=test2.c;

and i receive:
****
NOTICE:  Adding missing FROM-clause entry for table "test2"
 a | b | d
---+---+---
 *result*
****
Question: what's this- NOTICE:  Adding missing FROM-clause entry for table
          "test2"

version: PostgreSQL 7.1

Thanks..

Sorry for my english...:)


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: RH announcement is there
Next
From: Bruce Momjian
Date:
Subject: Red Hat to support PostgreSQL