Tom Lane kirjutas R, 03.10.2003 kell 18:34: > Michael Brusser <[EMAIL PROTECTED]> writes: > > But when I doubled the number of backslashes: > > SELECT smth. FROM tbl WHERE situation LIKE '%\\\\%'; > > - it actually worked fine. > > Backslash is special to both the string-literal parser and the LIKE code. > So when you write the above, the pattern value that arrives at the LIKE > processor has one less level of backslashing: > %\\% > and the LIKE processor interprets this as percent, a literal backslash, > and another percent.
Regarding the dollar-quoting discussions - Will we be able to write the above query as SELECT smth. FROM tbl WHERE WHERE situation LIKE $$%\\%$$; in 7.4 or is \ still special there ? if it is then one \ in regex in plpython still needs to be entered as \\\\\\\\ which has some geek coolness but would not be what I'd prefer to do on a regular basis. ---------------- Hannu ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
