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.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
