Re: Re: Escaping strings for inclusion into SQL queries
From:
Peter Eisentraut <peter_e(at)gmx(dot)net>
To:
Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
Cc:
<pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Re: Escaping strings for inclusion into SQL queries
Date:
2001-09-01 07:57:00
Message-ID:
Pine.LNX.4.30.0109010954520.722-100000@peter.localdomain (view raw or flat )
Thread:
2001-08-22 16:11:06 from Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
2001-08-23 18:09:24 from Christopher Masto <chris(at)netmonger(dot)net>
2001-08-23 20:17:05 from Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
2001-09-01 07:57:00 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-09-03 16:03:37 from Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
2001-09-03 20:28:49 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-09-03 20:59:54 from Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
2001-09-03 21:19:44 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-09-03 22:17:51 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-09-04 00:10:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-09-04 00:40:38 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-09-04 00:44:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-09-07 20:16:48 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-09-07 20:26:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-08-30 13:21:16 from Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
2001-08-30 22:43:55 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-08-30 23:07:36 from "Mitch Vincent" <mvincent(at)cablespeed(dot)com>
2001-08-30 23:32:58 from Alex Pilosov <alex(at)pilosoft(dot)com>
2001-08-31 01:27:28 from "Mitch Vincent" <mvincent(at)cablespeed(dot)com>
2001-08-31 00:37:26 from Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
2001-08-30 22:43:25 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-08-31 03:52:35 from Hannu Krosing <hannu(at)tm(dot)ee>
2001-08-31 17:03:04 from Barry Lind <barry(at)xythos(dot)com>
2001-08-31 16:03:57 from Hannu Krosing <hannu(at)tm(dot)ee>
2001-09-01 07:53:48 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2001-09-04 00:59:41 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-09-04 17:30:54 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-09-04 18:42:47 from Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
2001-09-07 21:26:05 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-09-07 22:02:32 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-09-11 06:26:23 from "Joe Conway" <joseph(dot)conway(at)home(dot)com>
2001-09-11 14:22:55 from Florian Weimer <Florian(dot)Weimer(at)RUS(dot)Uni-Stuttgart(dot)DE>
2001-09-12 04:20:31 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2001-09-13 17:00:26 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Lists:
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(at)gmx(dot)net http://funkturm.homeip.net/~peter
In response to
Responses
pgsql-hackers by date
Next :From: Vladimir V. ZolotychDate: 2001-09-01 12:18:37Subject : DIVIDEBY in PostgreSQL Previous :From : Peter EisentrautDate : 2001-09-01 07:53:48Subject : Re: Escaping strings for inclusion into SQL queries
