Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17916: Expression IN list translates to unqualified operator - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17916: Expression IN list translates to unqualified operator
Date
Msg-id CAKFQuwbLKduuWpS5Ld9HaWV8JiHw6XfZvLMLPf6D5NAOCAuO9w@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17916: Expression IN list translates to unqualified operator  (RekGRpth <rekgrpth@gmail.com>)
List pgsql-bugs
Tree view
On Wed, May 3, 2023 at 6:43 AM RekGRpth <rekgrpth@gmail.com> wrote:
How can I safely use an expression IN list in extensions?


search_path control is your only knob if you want to use IN.  Otherwise, you can typically reformulate an IN expression into an "op ANY" expression and then "op" can be schema-qualified.

David J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17917: to_tsquery syntax error
Next
From: Cyrus Lozano
Date:
Subject: Re: BUG #17917: to_tsquery syntax error