Skip site navigation (1) Skip section navigation (2)

BUG #2483: Wrong error report about missing entry in from clause

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: SAKATA TetsuoDate: 2006-06-16 10:46:17
Subject: Re: BUG #2480: Installation Error of RMP for RHEL4
Previous:From: Emilia VenturatoDate: 2006-06-16 09:16:50
Subject: Re: BUG #2481: select from table's join with geometries doesn't go

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group