On Fri, Oct 07, 2005 at 08:44:34AM +0100, Richard Huxton wrote: > CSN wrote: > >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. > > I think preference was why lowercase was chosen many moons ago. It's > stayed that way because otherwise existing users would be storming the > -hackers list with pitchforks and flaming torches. If any change was made I'm sure it would be to allow the user to decide which way case was folded. But IMHO, anyone messing around with object names that won't fold is asking for trouble anyway. -- 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
