Nesting and using LIKE and OR in postgres

Question

I'm trying to nest this query, but I am getting the error: invalid input syntax for type boolean: "%malfunction%".

select *
from (
select column_one, column_two
from table
group by column_one, column_two
) as new_table
where column_two like '%false%' or '%malfunction%' or '%accidental%' or '%mistaken%'
order by column_one

Column_two is not boolean but it's identifying it as one. I feel like I'm missing something small, but I can't find it. Help!

You must put the column name on each condition: where column_two like '%false%' or column_two like '%malfunction%' or column_two like '%accidental%' or column_two like '%mistaken%' — Michel Milezzi
– Michel Milezzi, Commented Jun 28, 2017 at 16:56
I knew I wasn't thinking correctly. This was exactly what I was missing. Thanks! — Dave
– Dave, Commented Jun 28, 2017 at 17:03

klin · Accepted Answer · 2017-06-28 17:32:19Z

1

You can use any(array[...]), example:

with test (col) as (
    values
    ('pear'), ('banana'), ('apple')
)

select *
from test
where col like any(array['%ea%', '%ba%']);

  col   
--------
 pear
 banana
(2 rows)

answered Jun 28, 2017 at 17:32

klin

123k15 gold badges240 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Varun Singh · Accepted Answer · 2017-06-28 17:01:12Z

0

Correct syntax is something like select col1, col2, from table_name where condition1 OR condition2 OR condition3 ...;

answered Jun 28, 2017 at 17:01

Varun Singh

92 bronze badges

Collectives™ on Stack Overflow

Nesting and using LIKE and OR in postgres

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related