abs value, power, sqrt - Mailing list pgsql-sql

From Michael Olivier
Subject abs value, power, sqrt
Date
Msg-id 19981120055303.6281.rocketmail@send105.yahoomail.com
Whole thread Raw
Responses Re: [SQL] abs value, power, sqrt  (Ulf Mehlig <umehlig@uni-bremen.de>)
Re: [SQL] abs value, power, sqrt  (Bob Smither <smither@C-C-I.Com>)
List pgsql-sql
Hi folks,

I previously posted this to pgsql-novice but haven't gotten an answer,
so I thought I'd try here.

I need a way to get abs value of a floating point number and (possibly
separate function for) abs value of an integer in a select statement.
Is there a function to do this? If not, how can I write a function to
do it?

Also how do I do squares and square roots? I saw some \|/ type notation
for square root in an SQL book, but I didn't get postgres to take that.

thanks,
Michael

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-sql by date:

Previous
From: Michael Olivier
Date:
Subject: Postgres 6.4 binary RPM for RH 5.1?
Next
From: Ulf Mehlig
Date:
Subject: Re: [SQL] abs value, power, sqrt