Re: Problem with index using regular expression

Thanks, that solved it

On Mon, Jun 6, 2011 at 9:10 AM, Alejandro Dubrovsky <
alex(dot)dubrovsky(at)hitwise(dot)com> wrote:

> 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"
>
>
>
>
> --
> Sent via psycopg mailing list (psycopg(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/psycopg
>