Re: sql standard: \' or ''

On Wed, 5 May 2004, CSN wrote:

> 
> --- Gregory Wood <gwood@ewebengine.com> wrote:
> > CSN wrote:
> > > I heard that the sql standard for escaping quotes
> > is
> > > '', and not \'. Is this true?
> > > 
> > > BTW, PHP's pg_escape_string returns \' and not ''.
> > 
> > Are you sure about that?
> > 
> > ~# php -r "print pg_escape_string(\"I can't believe
> > that quotes are 
> > escaped improperly\n\");"
> > I can''t believe that quotes are escaped improperly
> > 
> > Greg
> 
> Weird. Via cgi it escapes them as \' and via cli as
> '', for me anyway.

Maybe their different versions?  an older one that uses \' and a newer one 
that uses ''?

Just a guess.