From df76bda902517e655189717e4c1c8a3c9c34ca14 Mon Sep 17 00:00:00 2001
From: Aki Tuomi <cmouse@desteem.org>
Date: Sun, 13 Sep 2015 19:45:32 +0300
Subject: [PATCH] Handle NULL and boolean properly in gPGSql

---
 modules/gpgsqlbackend/spgsql.cc | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

diff --git a/modules/gpgsqlbackend/spgsql.cc b/modules/gpgsqlbackend/spgsql.cc
index 84bff3cccb..49f7ae309f 100644
--- a/modules/gpgsqlbackend/spgsql.cc
+++ b/modules/gpgsqlbackend/spgsql.cc
@@ -166,8 +166,16 @@ bool SPgSQL::getRow(row_t &row)
     return false;
   }
   
-  for(int i=0;i<PQnfields(d_result);i++)
-    row.push_back(PQgetvalue(d_result,d_count,i) ?: "");
+  for(int i=0;i<PQnfields(d_result);i++) {
+    if (PQgetisnull(d_result, d_count, i)) {
+      row.push_back("");
+    } else if (PQftype(d_result, i) == 16) { // BOOLEAN
+      char *val = PQgetvalue(d_result, d_count, i);
+      row.push_back(val[0] == 't' ? "1" : "0");
+    } else {
+      row.push_back(string(PQgetvalue(d_result, d_count, i)));
+    }
+  }
   d_count++;
   return true;
 }
-- 
2.47.2