On Aug 31, 2004, at 9:17 PM, Michael Glaesemann wrote:
What you need is a power operation for numeric, which I think you'd have to write yourself,
Looking a little closer, there is a pow() function that takes two numeric arguments and returns numeric.
<http://www.postgresql.org/docs/current/static/functions-math.html>
test=# select pow(2::numeric,100::numeric);
pow
--------------------------------------------------
1267650600228229401496703205376.0000000000000000
(1 row)Sorry for the misinformation.
If you'd like, I think you can overload the ^ operator to work on numeric as well if you don't want to use pow(). See the following page for more information.
<http://www.postgresql.org/docs/current/static/sql-createoperator.html>
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
