Changeset 2316:f8620977a163 for inc

Timestamp:

10/09/13 06:44:16 (12 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

default

Message:

Revamp query for PostgreSQL in order to use DISTNICT ON rather than GROUP BY, in getPosts(), addresses #989

File:

• inc/core/class.dc.blog.php (modified) (3 diffs)

inc/core/class.dc.blog.php

@@ -775 +775 @@
           elseif (!empty($params['sql_only'])) 
           {
-               $strReq = 'SELECT P.post_id ';
+               if ($this->core->con->driver() == 'pgsql' && isset($params['media'])) {
+                    $strReq = 'SELECT DISTINCT ON (P.post_id) P.post_id ';
+               } else {
+                    $strReq = 'SELECT P.post_id ';
+               }
           }
           else
@@ -791 +795 @@
                }
                
-               $strReq =
-               'SELECT P.post_id, P.blog_id, P.user_id, P.cat_id, post_dt, '.
+               if ($this->core->con->driver() == 'pgsql' && isset($params['media'])) {
+                    $strReq = 'SELECT DISTINCT ON (P.post_id) ';
+               } else {
+                    $strReq = 'SELECT ';
+               }
+               $strReq .=
+               'P.post_id, P.blog_id, P.user_id, P.cat_id, post_dt, '.
                'post_tz, post_creadt, post_upddt, post_format, post_password, '.
                'post_url, post_lang, post_title, '.$content_req.
@@ -958 +967 @@
           }
           
-          if (!$count_only && isset($params['media'])) {
+          if ($this->core->con->driver() != 'pgsql' && !$count_only && isset($params['media'])) {
                $strReq .= ' GROUP BY P.post_id ';
           }