postgresql where conditional, mixin "AND" "OR"

Question

I need to get the data from a DB and match two columns: Key and name, but I cant get it to work, if I use AND on both conditions:

...where lower(items.key_) SIMILAR TO lower('memory.size')
   and lower(items.name) SIMILAR TO lower('Memory Utilization%')
   and history.clock > '2020-08-12 03:05:32'

the query doesnt work because when items.key is similar to memory.size, items.name will never be similar to "Memory Utilization", so I try to do it with OR:

...where lower(items.key_) SIMILAR TO lower('memory.size')
   or lower(items.name) SIMILAR TO lower('Memory Utilization%')
   and history.clock > '2020-08-12 03:05:32'

But it doesnt work either.

Any Ideas?

Gordon Linoff · Accepted Answer · 2020-08-18 01:56:30Z

2

SIMILAR TO is not really the operator you want. You are using %, so that suggests LIKE:

where (lower(items.key_) like lower('memory.size') or
       lower(items.name) like lower('Memory Utilization%')
      ) and history.clock > '2020-08-12 03:05:32'

answered Aug 18, 2020 at 1:56

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

postgresql where conditional, mixin "AND" "OR"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related