From: | "Klaus Guntermann" <guntermann(dot)kl(at)pvw(dot)tu-darmstadt(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2483: Wrong error report about missing entry in from clause |
Date: | 2006-06-16 10:05:04 |
Message-ID: | 200606161005.k5GA54R7092535@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2483
Logged by: Klaus Guntermann
Email address: guntermann(dot)kl(at)pvw(dot)tu-darmstadt(dot)de
PostgreSQL version: 8.1.4
Operating system: Linux
Description: Wrong error report about missing entry in from clause
Details:
Hi,
with the following simplified example I get a false error message in the
second select statement, which is almost like the first one. The german text
of the error message is:
FEHLER: fehlender Eintrag in FROM-Klausel fr Tabelle dummy
The difference is that in the second statement all columns are qualified by
the table name.
The example is simplified from a larger select and normally one would not
phrase the selection this way. But nevertheless I think both versions of the
statement should work.
Thank you very much for your work on PostgreSQL!
Best regards,
Klaus
8<------------------- cut here
create temporary table dummy (myfield integer);
insert into dummy (myfield) values (1);
insert into dummy (myfield) values (2);
select myfield from dummy where myfield=1 union
select myfield from dummy where myfield=2 order by myfield;
select dummy.myfield from dummy where dummy.myfield=1 union
select dummy.myfield from dummy where dummy.myfield=2 order by
dummy.myfield;
8<------------------- cut here
From | Date | Subject | |
---|---|---|---|
Next Message | SAKATA Tetsuo | 2006-06-16 10:46:17 | Re: BUG #2480: Installation Error of RMP for RHEL4 |
Previous Message | Emilia Venturato | 2006-06-16 09:16:50 | Re: BUG #2481: select from table's join with geometries doesn't go |