Hi! If I use "some double-quoted stuff" in my query, this one can have two absolutely different meanings. Usually it is column name, but if I wrote this string with error, it silently converts into string literal.
I think, this silent behaviour is not very good. If it happens inside deeply nested subquery or inside aggregate function (e.g. having count(distinct "cusotmer_id") = 1 ) the query still works, but produces incorrect result. IMHO, it is better if double quoted string always mean "column name", and single quoted string stand for 'literal value' Best regards, Alexander mailto:[EMAIL PROTECTED]