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

Geoff Tolley wrote:

> postgres=# SELECT 'hello' WHERE '1' IN ('1' '2');
> ERROR:  syntax error at or near "'2'"
> LINE 1: SELECT 'hello' WHERE '1' IN ('1' '2');
>                                          ^
> postgres=# SELECT 'hello' WHERE '1' IN ('1'
> postgres(#  '2');
>  ?column?
> ----------
> (0 rows)

I guess what's happening here is this:

alvherre=# select 'a'
alvherre-# 'b';
 ?column?
----------
 ab
(1 fila)


I don't know much about this oddity but my first guess is that it's
mandated by the SQL standard.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support