note 99025 added to function.pg-query-params

Unfortunately the params will not respect string representations of NULL or NOW(). If your code pushes these values, they be considered a string and inserted literally as "NULL" and "NOW()". Ideally, there should be an additional parameter that you can assign to force this text as pgSQL functions/reserved words and not wrap them up as strings (assuming pgSQL's parameterized queries support this. This same problem also occurs for comma lists used in "WHERE column IN (1,2,3,4)", params treats "1,2,3,4" as a string, not a list of numbers, and runs it with quotes also. For debugging, I use this function to simulate params, keep in mind this is not 100% accurate, it only attempts to simulate the actual SQL that param queries create. function pg_query_params_return_sql($query, $array) { $query_parsed = $query; for ($a = 0, $b = sizeof($array); $a < $b; $a++) { if ( is_numeric($array[$a]) ) { $query_parsed = str_replace(('$'.($a+1)), str_replace("'","''", $array[$a]), $query_parsed ); } else { $query_parsed = str_replace(('$'.($a+1)), "'".str_replace("'","''", $array[$a])."'", $query_parsed ); } } return $query_parsed; } ---- Server IP: 64.71.164.2 Probable Submitter: 24.39.174.1 ---- Manual Page -- http://www.php.net/manual/en/function.pg-query-params.php Edit -- https://master.php.net/note/edit/99025 Del: integrated -- https://master.php.net/note/delete/99025/integrated Del: useless -- https://master.php.net/note/delete/99025/useless Del: bad code -- https://master.php.net/note/delete/99025/bad+code Del: spam -- https://master.php.net/note/delete/99025/spam Del: non-english -- https://master.php.net/note/delete/99025/non-english Del: in docs -- https://master.php.net/note/delete/99025/in+docs Del: other reasons-- https://master.php.net/note/delete/99025 Reject -- https://master.php.net/note/reject/99025 Search -- https://master.php.net/manage/user-notes.php