Re: [GENERAL] Strange error message when reference non-existent column foo."count"

2014-12-17 Thread Tom Lane
Patrick Krecker writes: > As expected, the following fails: > select count from foo; > ERROR: column "count" does not exist > LINE 1: select count from foo; >^ > But if I change the syntax to something I thought was equivalent: > select foo."count" from foo; > count > --- >

Re: [GENERAL] Strange error message when reference non-existent column foo."count"

2014-12-17 Thread Patrick Krecker
Sorry, I changed the email as I was writing it but I forgot to change the subject line. An appropriate subject would be 'Strange behavior when referencing non-existent column foo."count".' On Wed, Dec 17, 2014 at 2:50 PM, Patrick Krecker wrote: > > I encountered this today and it was quite surpri

[GENERAL] Strange error message when reference non-existent column foo."count"

2014-12-17 Thread Patrick Krecker
I encountered this today and it was quite surprising: select version(); version -- PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubu