> > Simplify: > > select 'a' > db-# 'b'; > ?column? > ---------- > ab > (1 row) > > This is not a bug. > > https://www.postgresql.org/docs/9.2/sql-syntax-lexical.html > > Two string constants that are only separated by whitespace with at > least one newline are concatenated and effectively treated as if the > string had been written as one constant. > > Geoff Shouldn't the output be 4 in that case since it is looking for('a','b','cd','e') and it should find all but cd.
