Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped - Mailing list pgsql-bugs

"Geoff Tolley" <geoff.tolley@yougov.com> wrote:

> postgres=# SELECT 'hello' WHERE '1' IN ('1'
> postgres(#  '2');

Per the SQL standard, that is the same as

SELECT 'hello' WHERE '1' IN ('12');

I believe that's intended to make it easier to code long string
literals without creating query text which has long line lengths, but
they (understandably) don't require a minimum length for the string
fragments.

-Kevin