The empty list?

Hi.

Is there someone who can elaborate on why the "empty list" is'nt
implemented in Postgresql?

This works:
# select 1 in (1,2,3);?column?
----------t
(1 row)

And this works:
jesper=# select * from test;id
----
(0 rows)

jesper=# select 1 in (select id from test);?column?
----------f
(1 row)

Whereas this gives a syntax error:

# select 1 in ();
ERROR:  syntax error at or near ")" at character 14
LINE 1: select 1 in ();                    ^
If everyone where writing their SQL by hand .. this would probably not
be a problem, but nowadays lots of people use ORM's for accessing the
database.. thus it would be nice if the SQL implementation was a bit
more generic like a "language".

Jesper
-- 
Jesper Krogh, jesper@krogh.cc