Re: Is this a bug ? - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Is this a bug ?
Date
Msg-id 1DAF2F6A-31A8-4376-A4E3-C33111B6B3F8@aol.com
Whole thread Raw
In response to Re: Is this a bug ?  (Geoff Winkless <pgsqladmin@geoff.dj>)
Responses Re: Is this a bug ?
List pgsql-general
>
> 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.



pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: Is this a bug ?
Next
From: Ron
Date:
Subject: Re: Is this a bug ?