Added 'random' as an order_by() option in Active Record.

1 files changed, 4 insertions, 3 deletions

diff --git a/system/database/drivers/postgre/postgre_driver.php b/system/database/drivers/postgre/postgre_driver.php
index beaa7931c..e54f9cceb 100644
--- a/system/database/drivers/postgre/postgre_driver.php
+++ b/system/database/drivers/postgre/postgre_driver.php
@@ -35,7 +35,8 @@ class CI_DB_postgre_driver extends CI_DB {
 	 * database engines, so this string appears in each driver and is

 	 * used for the count_all() and count_all_results() functions.

 	 */

-	var $count_string = "SELECT COUNT(*) AS numrows ";

+	var $_count_string = "SELECT COUNT(*) AS numrows ";

+	var $_random_keyword = ' RANDOM()'; // database specific random keyword

 

 	/**

 	 * Non-persistent database connection

@@ -285,8 +286,8 @@ class CI_DB_postgre_driver extends CI_DB {
 		if ($table == '')

 			return '0';

 

-		$query = $this->query($this->count_string .'FROM "'.$this->dbprefix.$table.'"');

-//		original query before count_string was used.  Kept for reference

+		$query = $this->query($this->_count_string .'FROM "'.$this->dbprefix.$table.'"');

+//		original query before _count_string was used.  Kept for reference

 //		$query = $this->query('SELECT COUNT(*) AS numrows FROM "'.$this->dbprefix.$table.'"');

 				

 		if ($query->num_rows() == 0)