Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XkDv3-0001KM-Ts for pgsql-sql@arkaria.postgresql.org; Fri, 31 Oct 2014 15:15:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XkDv3-0002Ng-9Z for pgsql-sql@arkaria.postgresql.org; Fri, 31 Oct 2014 15:15:17 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XkDv2-0002Mz-4N for pgsql-sql@postgresql.org; Fri, 31 Oct 2014 15:15:16 +0000 Received: from proofpoint1.mail.rice.edu ([128.42.201.100] helo=pp1.rice.edu) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XkDuy-0004eQ-5z for pgsql-sql@postgresql.org; Fri, 31 Oct 2014 15:15:13 +0000 Received: from pps.filterd (pp1.rice.edu [127.0.0.1]) by pp1.rice.edu (8.14.5/8.14.5) with SMTP id s9VFBWQ8029153; Fri, 31 Oct 2014 10:15:10 -0500 Received: from mh3.mail.rice.edu (mh3.mail.rice.edu [128.42.199.10]) by pp1.rice.edu with ESMTP id 1qbtdergqa-1; Fri, 31 Oct 2014 10:15:10 -0500 X-Virus-Scanned: by amavis-2.7.0 at mh3.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh3.mail.rice.edu (Postfix) with ESMTP id 51B794003F; Fri, 31 Oct 2014 10:15:10 -0500 (CDT) Received: by aart.rice.edu (Postfix, from userid 18612) id 47D13100722; Fri, 31 Oct 2014 10:15:10 -0500 (CDT) Date: Fri, 31 Oct 2014 10:15:10 -0500 From: "ktm@rice.edu" To: Filip =?utf-8?Q?Rembia=C5=82kowski?= Cc: Community PostgreSQL Subject: Re: INT8 / float casting question Message-ID: <20141031151510.GG32559@aart.rice.edu> References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.20 (2009-12-10) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 suspectscore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1402240000 definitions=main-1410310148 X-Pg-Spam-Score: -3.2 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On Fri, Oct 31, 2014 at 03:58:06PM +0100, Filip Rembiałkowski wrote: > psql.bin (9.3.4, server 9.3.5) > Type "help" for help. > > dev=# select (2^63-1)::INT8; > ERROR: bigint out of range > > > Does it HAVE to be so? > > > http://en.wikipedia.org/wiki/9223372036854775807 > > Thanks > Filip Yes: http://www.postgresql.org/docs/9.3/static/datatype.html Table 8-1: bigint, aliases int8 - signed eight-byte integer PostgreSQL does not have an unsigned integer type, since all the SQL ones are signed. Regards, Ken -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql