So I suppose since he's referring to a field, to pull it in all uppercase, he'd use... SELECT "ABC" from mytable; Am I correct?
David Stanaway wrote: > On Mon, 2002-06-17 at 20:25, Scot Wilcoxon wrote: > >>I've seen a few comments of people encountering this problem, but not >>yet a solution: >> >>Upper case field names in commands are forced to lower case and then not >>found. >> >>I was able to create a table with a field called "ABC". >> >>"SELECT ABC FROM mytable;" >>emits the error >>"no such attribute or function abc" >> > > > If it is possible, you will have a much easier time if you change you > schema to use case folded names > > EG: > CREATE TABLE Foo ( ... ) > rather than: CREATE TABLE "Foo" ( ... ) > > otherwise.. You will need to change your code to quote all references to > the name: > > EG: > $q = 'SELECT * from "Foo"'; > > If you don't put ["]'s around the object identifier, it gets case folded > to lower case. > > -- > David Stanaway > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
