Received: from thor.advocast.com (advocast18.dsl.inconnect.com.76.140.209.in-addr.arpa [209.140.76.44] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAKFxfs24495 for ; Mon, 20 Nov 2000 10:59:41 -0500 (EST) (envelope-from jellis@advocast.com) Received: from advocast83 (unknown [192.168.0.13]) by thor.advocast.com (Postfix) with SMTP id CB9C880313 for ; Mon, 20 Nov 2000 12:20:57 -0700 (MST) Message-ID: <047d01c0530b$0fafd0a0$0d00a8c0@dsl.inconnect.com> From: "Jonathan Ellis" To: References: <20001120165133.D25191@erm1.u-strasbg.fr> Subject: Re: numeric conversions? Date: Mon, 20 Nov 2000 08:59:33 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200011/156 X-Sequence-Number: 187 > is the type casting done automaticly? how? can i have an influence of > the cast order? is there an easy way to doing the rounding? bf2=# select 1 / 2 from dual; ?column? ---------- 0 (1 row) bf2=# select 1::float / 2 from dual; ?column? ---------- 0.5 (1 row) bf2=# select (1::float / 2)::int from dual; ?column? ---------- 0 (1 row) Also you have the functions round, floor, and ceil, which do what you would expect. -Jonathan