2009/12/25 Tom Lane <t...@sss.pgh.pa.us>: > Robert Haas <robertmh...@gmail.com> writes: >> I think maybe what we need here is a piece of syntax to indicate that a >> specific parameter should be substituted after first being passed >> through PQescapeStringConn. > > I agree that a global flag that changes the behavior of :foo is a > seriously bad idea. Alternate syntax would be much better, but how > exactly can we shoehorn that in? Maybe something like > :!foo
there are two quoting styles, so we need two syntax. I proposed :[var] and :{var} - for ident quoting and literal quoting. Theoretically we could to use :(var) for bytea escaping. :!foo isn't good idea. It is related to negation operator. Bracket or parenthesis are good readable and far to some custom pg operators. Regards Pavel Stehule > ie put some non-letter flags between the : and the variable name. > It would obviously not work to use ::foo, but I think many other > punctuation characters would be safe (would not conflict with any > likely SQL usage). We could have a couple of different flags to > signal whether you want single or double quoting of the variable > value. > > regards, tom lane > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers