Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 59C6C632599
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 25 Jun 2010 20:32:27 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 78112-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 25 Jun 2010 23:32:19 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com
	[209.85.212.46])
	by mail.postgresql.org (Postfix) with ESMTP id 6BF31632445
	for <pgsql-sql@postgresql.org>; Fri, 25 Jun 2010 20:32:20 -0300 (ADT)
Received: by vws9 with SMTP id 9so4513493vws.19
	for <pgsql-sql@postgresql.org>; Fri, 25 Jun 2010 16:32:19 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:subject:references:in-reply-to
	:x-enigmail-version:content-type:content-transfer-encoding;
	bh=Ww2jgm2bvbllsMe+kxW11hlyaGFKpUSutPi/545O31M=;
	b=jvxsV7aoYR6XRuhVR4fUVK4f+6MrdPdghxEiZ02cnxd1GEf40Q3S9JrBa/KQqrQLSN
	jXtdsU5yDwzgxoCfD3bYezg6pKvRdI0rlCZaXu2n8NWwtQ/De/+wStliCoSelSzvMgCD
	y0A95DIBsdP5jgCtFXK3fehVga/5uIQ99r8HM=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:x-enigmail-version:content-type
	:content-transfer-encoding;
	b=Kepmb4ZqnP6jxE/T/01RZvP3DVJmFS2euIMMdstD/MHvgi9ZR7wNoyhOyY9KpYSnsq
	fR/cdDESzoYxvJz2qFLUgxBUCxewkDl4auNzWj+IQblWjafpWbE5iQ8nEkg92dom84lb
	0NYbH5MaMw7g4v2mRfmHVODMqJQ8ZzyqfzFHI=
Received: by 10.229.250.204 with SMTP id mp12mr963791qcb.234.1277508738995;
	Fri, 25 Jun 2010 16:32:18 -0700 (PDT)
Received: from [192.168.1.100]
	(207-237-122-16.c3-0.wsd-ubr1.qens-wsd.ny.cable.rcn.com
	[207.237.122.16])
	by mx.google.com with ESMTPS id i20sm5755220qci.21.2010.06.25.16.32.17
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Fri, 25 Jun 2010 16:32:18 -0700 (PDT)
Message-ID: <4C253C80.4010802@gmail.com>
Date: Fri, 25 Jun 2010 19:32:16 -0400
From: Lee Hachadoorian <lee.hachadoorian@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.9) Gecko/20100423 Thunderbird/3.0.4
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Round integer division
References: <4C25334D.4040805@gmail.com>
	<201006251625.48231.adrian.klaver@gmail.com>
In-Reply-To: <201006251625.48231.adrian.klaver@gmail.com>
X-Enigmail-Version: 1.0.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201006/101
X-Sequence-Number: 34292

Thanks. That was a fairly recent post, too, but I couldn't come up with
the right keyword search to find it.

On 06/25/2010 07:25 PM, Adrian Klaver wrote:
> On Friday 25 June 2010 3:53:01 pm Lee Hachadoorian wrote:
>   
>> Is it documented anywhere that floating-point numbers round
>> "scientifically", that is 0.5 rounds to the nearest even number? 
>>     
> See here for explanation:
> http://archives.postgresql.org/pgsql-general/2010-03/msg00969.php
>
>   

-- 
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center