"Josh Kupershmidt" <schmi...@gmail.com> writes: > I noticed that Postgres in many cases will happily tokenize WHERE clauses > having no space between a condition and "AND" or "OR".
This has nothing to do with AND or OR. Any situation where you have some digits followed by something that can't be part of a number will be lexed as two separate tokens. I'm not sure we could change that, because it's a pretty basic aspect of a flex lexer; and even if we could I'm not eager to face the wrath of all the users whose queries would break. Leaving out "unnecessary" spaces is a pretty common habit. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs