Re: postgresql DB::quoteSmart

From:	Alexey Borzov	Date:	Mon, 29 Mar 2004 09:16:47 +0000
Subject:	Re: postgresql DB::quoteSmart
References:	1 2 3 4 5	Groups:	php.pear.dev
Request:	Send a blank email to pear-dev+get-26843@lists.php.net to get a copy of this message

Hi! Alan Knowles wrote:

add this to the top of the pgsql.php file: if (!function_exists('pg_escape_string')) {
    function pg_escape_string($v) {
        return preg_replace (.........
        }
} it adds a slight performance hit for older postgress boxes.. - but should be ok. BTW - I thought that the postgres backend only worked with newer versions of postgress anyway, as it uses the 'new' limit format...

There is no such stuff as "new" limit format. LIMIT # OFFSET # syntax was supported for as long as LIMIT #, #. The latter was removed, and the former is the "only" syntax now.