Add PostgreSQL support for LIMIT and oFFSET

diff --git a/lib/rico/ricoXmlResponse.php b/lib/rico/ricoXmlResponse.php
index 30575e3..33bd798 100644 (file)
--- a/lib/rico/ricoXmlResponse.php
+++ b/lib/rico/ricoXmlResponse.php
@@ -82,6 +82,11 @@ class ricoXmlResponse {
         $totcnt=$this->Query2xmlRaw_Limit($this->sqltext, $offset, $numrows, 0);
         break;
 
+      case "PostgreSQL":
+        $this->sqltext=$this->oParse->UnparseSelect()." LIMIT ".($numrows + 1) . " OFFSET ".$offset;
+        $totcnt=$this->Query2xmlRaw_Limit($this->sqltext, $offset, $numrows, 0);
+        break;
+
       default:
         $this->sqltext=$this->oParse->UnparseSelect();
         $totcnt=$this->Query2xmlRaw($this->sqltext, $offset, $numrows);