Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 876B39FB4E9 for ; Fri, 27 Jul 2007 07:38:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 81267-04 for ; Fri, 27 Jul 2007 07:37:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 1084F9FB4C7 for ; Fri, 27 Jul 2007 07:38:05 -0300 (ADT) Received: from hawking.credativ.lan (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id C07AC784C3; Fri, 27 Jul 2007 12:35:03 +0200 (CEST) From: Peter Eisentraut To: pgsql-docs@postgresql.org Subject: Re: BIGINT is in apparently SQL:2003 Date: Fri, 27 Jul 2007 12:37:55 +0200 User-Agent: KMail/1.9.5 Cc: Michael Glaesemann References: <05510444-AACD-4FE4-9509-3BC3A4DA4526@seespotcode.net> In-Reply-To: <05510444-AACD-4FE4-9509-3BC3A4DA4526@seespotcode.net> MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1252" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200707271237.55679.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/18 X-Sequence-Number: 4345 Am Donnerstag, 26. Juli 2007 04:35 schrieb Michael Glaesemann: > > SQL only specifies the integer types integer (or int) and smallint. > > The type bigint, and the type names int2, int4, and int8 are > > extensions, which are shared with various other SQL database systems. > > In the SQL:2003 draft I have (ISO/IEC 9075-2:2003 (E)), BIGINT is > listed as well as SMALLINT and INT. I have adjusted this part. -- Peter Eisentraut http://developer.postgresql.org/~petere/