The following bug has been logged online:

Bug reference: 1817
Logged by: nguyen
Email address: ngthanhthuat@yahoo.com
PostgreSQL version: 8.0.3
Operating system: windown2000 server
Description: column not exist
Details:

when i excecuted sql command "select * from employee" then result were ok,
but if sql command were "select employeeID from employee" then have error
return : column employeeID does not exist

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

nguyen wrote:
>
> when i excecuted sql command "select * from employee" then result were ok,
> but if sql command were "select employeeID from employee" then have error
> return : column employeeID does not exist

This error is usually produced because a column of that name does not exist.

Since you are using a mixed-case column-name, I'm guessing that's the
cause of the problem. If you create a column mixed-case by quoting it:

CREATE TABLE employee (
"employeeID" int4
...
)

Then you need to quote it when you use it:

SELECT "employeeID" FROM employee;

If you don't quote when you create, then the column is case-insensitive.

See the mailing-list archives for plenty of details.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org