Received: from send105.yahoomail.com (send105.yahoomail.com [205.180.60.128]) by hub.org (8.9.1/8.9.1) with SMTP id AAA08476 for ; Fri, 20 Nov 1998 00:50:20 -0500 (EST) (envelope-from molivier@yahoo.com) Message-ID: <19981120055303.6281.rocketmail@send105.yahoomail.com> Received: from [207.181.255.230] by send105.yahoomail.com; Thu, 19 Nov 1998 21:53:03 PST Date: Thu, 19 Nov 1998 21:53:03 -0800 (PST) From: Michael Olivier Subject: abs value, power, sqrt To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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