Re: BUG #14518: FTS index not triggered when using function to provide the tsquery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Francisco Grau <grau(dot)fran(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14518: FTS index not triggered when using function to provide the tsquery
Date: 2017-01-27 14:04:48
Message-ID: 28388.1485525888@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Francisco Grau <grau(dot)fran(at)gmail(dot)com> writes:
> That makes perfect sense. It is weird that it works using the CTE though.

Well, the CTE forces single evaluation, so that the value is a constant
again from the outer query's perspective.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message sellier nicolas 2017-01-27 14:16:04
Previous Message Francisco Grau 2017-01-27 13:58:31 Re: BUG #14518: FTS index not triggered when using function to provide the tsquery