persistence@glassfish.java.net

Re: Math expressions

From: Mitesh Meswani <Mitesh.Meswani_at_Sun.COM>
Date: Fri, 04 Apr 2008 20:33:06 -0700

You can either
-Do the multiplication in memory once you retrieve the result
or
-Use native sql


Kiril Minanov wrote:
> Hi,
>
> I have the following query:
>
> How can I make this query work
> It seems that the *, +, -, / operators are not supported in the select
> clause
>
> SELECT
> p.price * p.price
> FROM
> Products
>