Re: Escape percent sign in QuerySet.extra()

Sorry I hadn't seen your comment, have you tried %%% ? On Mon, Dec 3, 2012 at 7:28 AM, Joseph Mutumi wrote: > I think to escape a % use %% > > > On Sun, Dec 2, 2012 at 1:16 PM, Martin Svoboda > wrote: > >> Hi, >> I want use postgresql pg_trgm module in django. pg_trgm defines special >> operato

Re: Escape percent sign in QuerySet.extra()

I think to escape a % use %% On Sun, Dec 2, 2012 at 1:16 PM, Martin Svoboda wrote: > Hi, > I want use postgresql pg_trgm module in django. pg_trgm defines special > operator percent sign. How should I escape it in django query extra method? > > # Pure SQL > SELECT content, similarity(content, 'te

Re: Escape percent sign in QuerySet.extra() method

On Sunday, December 2, 2012 1:55:05 AM UTC-8, Martin Svoboda wrote: > > Hello, > I'm want to use functionality of postgresql module > pg_trgmin django. > pg_trgm uses special operator % (percent sign). I don't know how > should I escape it

Escape percent sign in QuerySet.extra() method

Hello, I'm want to use functionality of postgresql module pg_trgmin django. pg_trgm uses special operator % (percent sign). I don't know how should I escape it in query extra method. # pure SQL SELECT content, similarity(content, 'string')

Escape percent sign in QuerySet.extra()

Hi, I want use postgresql pg_trgm module in django. pg_trgm defines special operator percent sign. How should I escape it in django query extra method? # Pure SQL SELECT content, similarity(content, 'text') AS sml FROM table WHERE content % 'text' ORDER BY sml DESC, content; # Extra throws