From c59d4680f9ff57b0260083c15b4aa81b7bd34bd9 Mon Sep 17 00:00:00 2001
From: Aki Tuomi <cmouse@cmouse.fi>
Date: Sat, 12 Sep 2015 23:48:56 +0300
Subject: [PATCH] Handle booleans correctly in gPGSql

---
 modules/gpgsqlbackend/spgsql.cc | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/modules/gpgsqlbackend/spgsql.cc b/modules/gpgsqlbackend/spgsql.cc
index bcb1c7bda..b6aa597f5 100644
--- a/modules/gpgsqlbackend/spgsql.cc
+++ b/modules/gpgsqlbackend/spgsql.cc
@@ -91,6 +91,9 @@ public:
     for(i=0;i<PQnfields(d_res);i++) {
       if (PQgetisnull(d_res, d_residx, i)) {
         row.push_back("");
+      } else if (PQftype(d_res, i) == 16) { // BOOLEAN
+        char *val = PQgetvalue(d_res, d_residx, i);
+        row.push_back(val[0] == 't' ? "1" : "0");
       } else {
         row.push_back(string(PQgetvalue(d_res, d_residx, i)));
       }
-- 
2.40.0