Re[2]: [SQL] abs value, power, sqrt

Hello Bob,

sabato, 21 novembre 98, you wrote:

BS> On Thu, 19 Nov 1998, Michael Olivier wrote:

BS> :Hi folks,
BS> :
BS> :I previously posted this to pgsql-novice but haven't gotten an answer,
BS> :so I thought I'd try here.
BS> :
BS> :I need a way to get abs value of a floating point number and (possibly
BS> :separate function for) abs value of an integer in a select statement.
BS> :Is there a function to do this? If not, how can I write a function to
BS> :do it?
BS> :
BS> :Also how do I do squares and square roots? I saw some \|/ type notation
BS> :for square root in an SQL book, but I didn't get postgres to take that.

------------------------------------------------------------------------
funct PostgreSQL result remarks
------------------------------------------------------------------------
ABS: select @ -12 12 absolute value
MODULE: select 100 % 3 1 module
POWER: select dpow(12,2) 144 power
ROUND: select dround(12.7) 13 round
SQRT: select dsqrt(144) 12 square root
TRUNC: select dtrunc(1.2) 1 truncate int value
ROOT3: select dcbrt(27) 3 cube root
LOG: select dlog1(100) 4.60517018598809 logarithm
EXP: select dexp(2) 7.38905609893065 exponent
------------------------------------------------------------------------

Jose'