Changeset 436142
- Timestamp:
- 09/10/2011 10:14:28 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
postgresql-for-wordpress/trunk/pg4wp/driver_pgsql.php
r436140 r436142 146 146 // Here we need to convert the latest query into a COUNT query 147 147 $sql = $GLOBALS['pg4wp_numrows_query']; 148 echo '<pre>'.$sql.'</pre>';149 148 // Remove any LIMIT ... clause (this is the blocking part) 150 149 $pattern = '/\s+LIMIT.+/'; 151 150 $sql = preg_replace( $pattern, '', $sql); 152 echo '<pre>'.$sql.'</pre>';153 151 // Now add the COUNT() statement 154 152 $pattern = '/SELECT\s+([^\s]+)\s+(FROM.+)/'; 155 153 $sql = preg_replace( $pattern, 'SELECT COUNT($1) $2', $sql); 156 echo '<pre>'.$sql.'</pre>';157 154 } 158 155
Note: See TracChangeset
for help on using the changeset viewer.