From 6d101df7dc3dc6f5542ccb11d626dcacbd148de6 Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Mon, 28 Nov 2005 18:38:49 +0000 Subject: - some SQL:2003 changes (basicly joins, mysql5 is sql:2003 compliant in strict mode now) - postgresql not supporting this standard. :/ - acp changes git-svn-id: file:///svn/phpbb/trunk@5313 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/includes/db/postgres.php | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'phpBB/includes/db/postgres.php') diff --git a/phpBB/includes/db/postgres.php b/phpBB/includes/db/postgres.php index 72590d6330..f371202578 100644 --- a/phpBB/includes/db/postgres.php +++ b/phpBB/includes/db/postgres.php @@ -120,6 +120,11 @@ class dbal_postgres extends dbal { global $cache; + if (strpos($query, 'SELECT') === 0 && strpos($query, 'FROM (') !== false) + { + $query = preg_replace('#FROM \((.+)\) #', 'FROM \1 ', $query); + } + // EXPLAIN only in extra debug mode if (defined('DEBUG_EXTRA')) { -- cgit v1.2.1