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