From d4a597fd4bb2713b8f828211db6caa1b44c46faf Mon Sep 17 00:00:00 2001
From: Angie Byron <webchick@24967.no-reply.drupal.org>
Date: Fri, 11 Sep 2009 02:47:11 +0000
Subject: #561104 by Crell: Added support for random ordering in dynamic select
 queries.

---
 includes/database/pgsql/query.inc | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'includes/database/pgsql')

diff --git a/includes/database/pgsql/query.inc b/includes/database/pgsql/query.inc
index 9005a1a83..ac5072c76 100644
--- a/includes/database/pgsql/query.inc
+++ b/includes/database/pgsql/query.inc
@@ -173,3 +173,13 @@ class UpdateQuery_pgsql extends UpdateQuery {
     return $stmt->rowCount();
   }
 }
+
+class SelectQuery_pgsql extends SelectQuery {
+
+  public function orderRandom() {
+    $alias = $this->addExpression('RANDOM()', 'random_field');
+    $this->orderBy($alias);
+    return $this;
+  }
+
+}
-- 
cgit v1.2.3