From 274f34352e057034fae79441c7fd56ba011a560a Mon Sep 17 00:00:00 2001
From: Andrey Kutejko <andy128k@gmail.com>
Date: Thu, 25 Jul 2013 23:11:23 +0300
Subject: [PATCH] add coalesce function

---
 ipf/orm/expression/driver.php | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/ipf/orm/expression/driver.php b/ipf/orm/expression/driver.php
index a256d8e..5c7baa2 100644
--- a/ipf/orm/expression/driver.php
+++ b/ipf/orm/expression/driver.php
@@ -107,6 +107,13 @@ class IPF_ORM_Expression_Driver extends IPF_ORM_Connection_Module
         return 'NOW()';
     }
 
+    public function coalesce($expression1, $expression2)
+    {
+        $expression1 = $this->getIdentifier($expression1);
+        $expression2 = $this->getIdentifier($expression2);
+        return 'COALESCE(' . $expression1 . ', ' . $expression2 . ')';
+    }
+
     public function soundex($value)
     {
         throw new IPF_ORM_Exception('SQL soundex function not supported by this driver.');
@@ -277,4 +284,5 @@ class IPF_ORM_Expression_Driver extends IPF_ORM_Connection_Module
         }
         return $m . '(' . implode(', ', $a) . ')';
     }
-}
\ No newline at end of file
+}
+
-- 
2.49.0