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
