On 06/06/11 17:07, Federico Di Gregorio wrote: > On 06/06/11 09:03, Håvard Wahl Kongsgård wrote: >> substring(nodes.name <http://nodes.name> from >> E'\\w.*\\s(\\w.*)$|\\w+\\s(\\w.*)$') = substring(income.name >> <http://income.name> from E'\\w.*\\s(\\w.*)$|\\w+\\s(\\w.*)$') limit 1000") > > Try doubling every '\' because that's a Python escape character too and > you want to send to the database the "\\X" sequence, not "\X"; i.e., > > ... from E'\\\\w.*\\\\s(\\\\w.*)$|\\\\w+\\\\s(\\\\w.*)$') ... >
It's easier to just put an r at the front of the string. ie
r"SELECT Distinct On (nodes.id) nodes.ID from nodes inner join income on
substring(nodes.name from E'\\w.*\\s(\\w.*)$|\\w+\\s(\\w.*)$') = substring(income.name from E'\\w.*\\s(\\w.*)$|\\w+\\s(\\w.*)$') limit 1000"