Return to Answer

Internally, there are two separate forms of IN, as well as for the ANY construct.

Internally, there are two separate forms of IN, and also two separate forms of the ANY construct.

CREATE INDEX t_row_idx2 ON t ((t.*));

Shorter, equivalent syntax:

But the first variant is safer. The second variant would resolve to the column if a column of the same name should exist.

• Is there a way to usefully index a text column containing regex patterns?

  WHERE (a,b) IN ((1,1),(1,2));

• Is there a way to usefully index a text column containing regex patterns?

    WHERE (a,b) IN ((1,1),(1,2));
  

• IN vs ANY operator in PostgreSQL

• Pass multiple sets or arrays of values to a function

• Is there a way to usefully index a text column containing regex patterns?

  WHERE (a,b) IN ((1,1),(1,2));

• IN vs ANY operator in PostgreSQL

• Pass multiple sets or arrays of values to a function

• Is there a way to usefully index a text column containing regex patterns?

  WHERE (a,b) IN ((1,1),(1,2));