4 ms·

> SQL parser is very finnicky In what way is it finicky?

• raverbashing 13y ago
  http://www.merriam-webster.com/dictionary/finnicky http://www.merriam-webster.com/dictionary/finnicky For example, MySQL accepts both ' and " as string delimiters. It's very fun trying to get around PGSQL not understanding what you want to do while MySQL understands. It doesn't require ';' to mark the end of a command
  • dragonwriter 13y ago
    > For example, MySQL accepts both ' and " as string delimiters. That is, in its default mode, MYSQL does not accept ANSI-standard quoted identifiers (supporting only non-standard use of backquotes for quoted identifiers), and instead treats double quotes as equivalent to single quotes for strings. (Of course, MYSQL has a non-default option to support the standard.) PostgreSQL, OTOH, supports the standard out of the box, and treates double quoted material as quoted identifiers. Neither behavior is more finnicky, one is just standards-compliant. > It's very fun trying to get around PGSQL not understanding what you want to do while MySQL understands This would appear to only be an issue if your only RDBMS experience is with MySQL and you are adapted to its quirks, since if you have experience with other DBs which adhere to the ANSI standards for basic behavior, MySQL will, by default, be more likely to not understand what you mean than PostgreSQL.