Dana Hudes wrote: > The documentation clearly states in section "1.1.1 Identifiers and > Keywords" that "Identifier and key word names are case insensitive". > It goes on to give an example where a column name is used in lower > case and in upper case or any mixture. > > I have found that the actual implemented behavior is not > in conformance with the above. It can be demonstrated in psql > if you create a column whose name is mixed case , e.g. "DocRoot" in > table "websites" that > select "DocRoot" from "websites"; > works and that > select "docroot" from "websites" does not.
Reread the above section up to the very end and then come back. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org