Revision 570 trunk/org.gvsig.postgresql/org.gvsig.postgresql.provider/src/main/java/org/gvsig/postgresql/dal/expressionbuilderformatter/ILike.java

View differences:

ILike.java
36 36
        List<Value> parameters = ((Function) function).parameters();
37 37
        String p1 = parameters.get(0).toString(formatter);
38 38
        String p2 = parameters.get(1).toString(formatter);
39
        String r = MessageFormat.format("(({0}).LOWER() LIKE ({1}).LOWER())", p1, p2);
39
        String r = MessageFormat.format("({0}) ~~* ({1})", p1, p2);
40 40
        return r;
41 41
    }
42 42
    

Also available in: Unified diff