CODEWITHSUNDEEP
nhibernatepostgresql
Nicolas Cornu
Nicolas Cornu

Reputation: 11

Nhibernate - How to get rid of unwanted text cast

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

Upvotes: 1

Views: 146

Answers (1)

Joshua D. Drake
Joshua D. Drake

Reputation: 1012

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

Upvotes: 1

Related Questions