From: | John W Higgins <wishdev(at)gmail(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Is this a bug ? |
Date: | 2019-10-23 16:00:50 |
Message-ID: | CAPhAwGx+YDHoLfwhfRoJxagx1iVu+p6kWWmfZ0v=+aZoRkc0dA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Oct 23, 2019 at 8:56 AM Ravi Krishna <sr_krishna(at)aol(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Geoff Winkless | 2019-10-23 16:03:10 | Re: Is this a bug ? |
Previous Message | Tom Lane | 2019-10-23 16:00:14 | Re: Is this a bug ? |