Fix returning check for Postgres.

taylorotwell · taylorotwell · commit d1ae2324fdff · 2013-05-14T00:55:26.000-05:00
diff --git a/laravel/database/connection.php b/laravel/database/connection.php
@@ -197,7 +197,7 @@ public function query($sql, $bindings = array())
 		// For insert statements that use the "returning" clause, which is allowed
 		// by database systems such as Postgres, we need to actually return the
 		// real query result so the consumer can get the ID.
-		elseif (stripos($sql, 'insert') === 0 and stripos($sql, 'returning') !== false)
+		elseif (stripos($sql, 'insert') === 0 and stripos($sql, ') returning') !== false)
 		{
 			return $this->fetch($statement, Config::get('database.fetch'));
 		}

Original file line number	Diff line number	Diff line change
`@@ -197,7 +197,7 @@ public function query($sql, $bindings = array())`
`197`	`197`	`// For insert statements that use the "returning" clause, which is allowed`
`198`	`198`	`// by database systems such as Postgres, we need to actually return the`
`199`	`199`	`// real query result so the consumer can get the ID.`
`200`		`- elseif (stripos($sql, 'insert') === 0 and stripos($sql, 'returning') !== false)`
	`200`	`+ elseif (stripos($sql, 'insert') === 0 and stripos($sql, ') returning') !== false)`
`201`	`201`	`{`
`202`	`202`	`return $this->fetch($statement, Config::get('database.fetch'));`
`203`	`203`	`}`