abs value, power, sqrt

Поиск
Список
Период
Сортировка
От Michael Olivier
Тема abs value, power, sqrt
Дата
Msg-id 19981120055303.6281.rocketmail@send105.yahoomail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Michael Olivier
Дата:
Сообщение: Postgres 6.4 binary RPM for RH 5.1?
Следующее
От: Ulf Mehlig
Дата:
Сообщение: Re: [SQL] abs value, power, sqrt