In ClojureQL how can I make a where clause case insensitive?

Question

In ClojureQL how can I make a where clause case insensitive? I am trying to add UPPER or something to do this in the where clause but I can't figure out how to do this

Daan · Accepted Answer · 2011-09-05T16:36:34.847

2

In ClojureQL you can call a function like this:

:function/col

So something like this should work according to the documentation:

(select (table :users) (where (= :LOWER/name john)))

edited Sep 05 '11 at 16:36

answered Sep 04 '11 at 16:56

Daan

9,984
2
30
36

I was getting "function lcase(character varying) does not exist". I changes it to LOWER though and it works now. Thanks! – yazz.com Sep 05 '11 at 11:18

In ClojureQL how can I make a where clause case insensitive?

1 Answers1