Karlo Lozovina wrote:
I was just wondering, why does SA quote column names that have mixed
case in them, and leaves them unquoted for lowercase column names?
Because in general SQL engines tend to be case-insensitive, that is,
under most of them the query
SELECT column_a, column_b FROM table
because
a) SQL-standard says names are caseless - Fun anf fUn are same thing
b) most SQLs allow mixed case but require it in quotes, and some are
_very_ picky about it (postgres)
c) readability - lowercase names differs well from uppercase reserved
words
On Thursday 15 March 2007 06:26:03