Fixed list adaptation.

2 files changed, 4 insertions, 1 deletions

diff --git a/ChangeLog b/ChangeLog
index 14628fb..9af3b7f 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,5 +1,8 @@
 2006-06-11  Federico Di Gregorio  <fog@initd.org>
 
+	* Applied patch to adapt an empty list into an empty array
+	and not to NULL (from iGGy, closes: #108).
+
 	* Applied patch from wkv to avoid under-allocating query
 	space when the parameters are not of the right type
 	(Closes: #110).
diff --git a/psycopg/adapter_list.c b/psycopg/adapter_list.c
index d03626d..d29512f 100644
--- a/psycopg/adapter_list.c
+++ b/psycopg/adapter_list.c
@@ -46,7 +46,7 @@ list_quote(listObject *self)
     
     /* empty arrays are converted to NULLs (still searching for a way to
        insert an empty array in postgresql */
-    if (len == 0) return PyString_FromString("NULL");
+    if (len == 0) return PyString_FromString("{}");
     
     tmp = PyTuple_New(len);