Description: ------------ Simply, DB/pgsql.php is not expecting WITH queries. I suppose it's on Line 356 of DB/pgsql.php. Test script: --------------- //postgres=> SELECT * FROM tree ; // id | parent //----+-------- // 1 | // 2 | 1 // 3 | 1 // 4 | 2 //(4 rows) $ret = $db->getAll( 'WITH RECURSIVE r AS (SELECT * FROM tree WHERE id = 1 UNION ALL SELECT tree.* FROM tree, r WHERE tree.parent = r.id)' . ' SELECT * FROM r ORDER BY id' ); var_dump($ret); Expected result: ---------------- array(4) { [0]=> array(2) { ["id"]=> string(1) "1" ["parent"]=> NULL } [1]=> array(2) { ["id"]=> string(1) "2" ["parent"]=> string(1) "1" } [2]=> array(2) { ["id"]=> string(1) "3" ["parent"]=> string(1) "1" } [3]=> array(2) { ["id"]=> string(1) "4" ["parent"]=> string(1) "2" } } Actual result: -------------- int(1)

Actually, I do NOT know if WITH sub-queries can be followed by main queries other than SELECTs... If UPDATE or things like that can be the main query, Fixing this problem might not be simple as adding 'WITH' to Line 356 of DB/pgsql.php. Thanks anyway for handling this.

This bug has been fixed in SVN. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.