NOTICE: adding missing FROM-clause entry for table

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: NOTICE: adding missing FROM-clause entry for table
Date: 2004-09-28 01:51:14
Message-ID: 20040928015114.76259.qmail@web51409.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear Group,
I am creating a temporary table from an existing table
and I get the following error. I havent defined any
relationship between these two tables. Althought I got
the result what i wanted but I did not understand the
NOTICE that compiler gives.

=> select DISTINCT *,*,*,*,*,*,*,* INTO temp_table
FROM <existing table1> where * =
table2.table_2_colName;

NOTICE: adding missing FROM-clause entry for table
"probe_set"

Could any one please help me to understand this.

Thank you.

Kumar


__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kumar S 2004-09-28 02:11:57 Duplicate entries with different primary keys (SERIAL)
Previous Message D. Duccini 2004-09-28 00:14:09 date_trunc'd timestamp index possible?