Nhibernate - How to get rid of unwanted text cast

Question

Hello,

I am using Nhibernate 2 and PostgreSql

The above code generate a query with a cast on expression

res = _session.CreateCriteria(typeof(C))
                    .Add(Restrictions.Eq("Exp", Exp))
                    .AddOrder(new Order("Fr", false))
                    .SetMaxResults(MW)
                    .List<C>();

Exp is a character varying(30)

The generated query looks like: SELECT ... FROM table WHERE Exp = 'text':: text ...

I want to get rid of cast 'text":: text because the index is not used.

Nicolas

Answer 1

That doesn't make sense. The cast shouldn't matter. Is this a UTF-8 database?