What's it: NOTICE: Adding missing FROM-clause entry

From: "Vitaliy V(dot) Romanets" <vitaliy(at)gu(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: What's it: NOTICE: Adding missing FROM-clause entry
Date: 2001-06-25 14:10:12
Message-ID: Pine.LNX.4.10.10106251652570.337-100000@raven.gu.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...:)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Vecernik 2001-06-25 14:16:15 forms and reports
Previous Message Jan Wieck 2001-06-25 13:51:35 RH announcement is there