From dfc88cb95226ce20973c0d40e15d53b8950ec233 Mon Sep 17 00:00:00 2001
From: Nathan Gass
Date: Tue, 1 Sep 2020 12:24:04 +0200
Subject: generate postgres compatible where statements

---
 it_dbi.class | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/it_dbi.class b/it_dbi.class
index b3fd80b..dd0fb14 100644
--- a/it_dbi.class
+++ b/it_dbi.class
@@ -426,7 +426,7 @@ function _where($params)
 							$query .= $sep . "$field IS NOT NULL AND (" . join(" OR ", $parts) . ")";	# Check for IS NOT NULL to take advantage of index
 						}
 						else
-							$query .= $sep . "1";
+							$query .= $sep . "TRUE";
 						break;
 
 					case 'MATCH':
@@ -448,7 +448,7 @@ function _where($params)
 								$query .= "$sep$field $op (" . join(",", $qvals) . ")";	 # null is mapped to ''
 							}
 							else
-								$query .= $sep . (($op == 'IN') ? "0" : "1");
+								$query .= $sep . (($op == 'IN') ? "FALSE" : "TRUE");
 
 							break;
 						}
-- 
cgit v1.2.3