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