On Wed, Oct 23, 2019 at 8:56 AM Ravi Krishna <sr_kris...@aol.com> wrote:
> > > > 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. > > And that means there are 3 options on the table = a, b, and e - where is the 4th item? cd is not in the table so it cannot be found. John
