Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > I am thinking it is best to always use E'' in that case. OK? > > I'm planning to revert it to the previous logic: E if there's any > backslash. I think we have to do likewise in quote_literal() for > much the same reason: insufficient confidence that we know how > the result will be used. (Note dblink uses quote_literal for > strings it will send to the other database.)
Good point. Good thing only dblink and /contrib/tablefunc use quote_literal().. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings