Re: Re: Escaping strings for inclusion into SQL queries - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Re: Escaping strings for inclusion into SQL queries
Date
Msg-id Pine.LNX.4.30.0109010954520.722-100000@peter.localdomain
Whole thread Raw
In response to Re: Re: Escaping strings for inclusion into SQL queries  (Florian Weimer <Florian.Weimer@RUS.Uni-Stuttgart.DE>)
Responses Re: Re: Escaping strings for inclusion into SQL queries  (Florian Weimer <Florian.Weimer@RUS.Uni-Stuttgart.DE>)
List pgsql-hackers
Florian Weimer writes:

> The first version escaped ' with ''.  I changed it when I noticed that
> if \' is used instead, the same function can be used for strings
> ('...') and identifiers ("...").

Last time I checked (15 seconds ago), you could not escape " with \ in
PostgreSQL.  The identifer parsing rules are a bit different from strings.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: INTERVAL type: SQL92 implementation
Next
From: Peter Eisentraut
Date:
Subject: Re: Escaping strings for inclusion into SQL queries