Re: DBI/DBD::Pg changing my sql query somehow?

lolling out with what google fetched me:

the last one seems more plausible as the column name it is complaining about contains cased letters.

ps. i am just the googler. there are Pg experts here

Comment on Re: DBI/DBD::Pg changing my sql query somehow?

Replies are listed 'Best First'.
Re^2: DBI/DBD::Pg changing my sql query somehow? by kikuchiyo (Hermit) on Jul 24, 2024 at 20:32 UTC
Ugh, that second link. It scratches at the right place, but the conclusion is wildly wrong. This Stackoverflow answer explains it better: https://stackoverflow.com/questions/21796446/postgres-case-sensitivity But it's best to rely on the official documentation: https://www.postgresql.org/docs/16/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS	[reply]