Is it possible to do simple column math with the criteria api? I have a float column which I'd like to add or subtract a fixed value to. I suppose that an add(Restrictions.sql()) might work for what I need.

I'm using Hibernate 3.

Here is further clarification on my problem. Here is my table:

Address
---------

line1 varchar
line2 varchar
city varchar
state varchar
distance float
.
.
.


I want to do a query and within that query use criteria something like this:

where distance - x < 50

x is a fixed amount I want to subtract

How about doing som simple math...
Converting
where distance - x < 50
To
where distance < (50 + x)

eg
Restrictions.lt("distance", 50+x);

/Kristoffer

I've thought of that but I'm also using setFirst(offset) and setMaxResult(page_size). I'm trying to just get 1 page of results and also avoid any post resultset processing.

Thanks