Yep, I think the SQL spec says fold to uppercase. I'm not sure why PostgreSQL folds to lowercase instead, but if folding has to occur, I prefer lowercase. CSN --- "Jim C. Nasby" <jnasby@xxxxxxxxxxxxx> wrote: > On Thu, Oct 06, 2005 at 12:54:43PM -0700, CSN wrote: > > - lowercase folding. I DO sometimes wish I could > use > > fieldID, etc. without quoting it. > > I believe that may be against ANSI SQL. In any case, > the only databases > I can think of that don't fold-case in some form are > MySQL and Access. > -- > Jim C. Nasby, Sr. Engineering Consultant > jnasby@xxxxxxxxxxxxx > Pervasive Software http://pervasive.com > work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf > cell: 512-569-9461 > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
