Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D0B639FB30C for ; Fri, 27 Jul 2007 11:33:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45105-05 for ; Fri, 27 Jul 2007 11:33:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mtao03.charter.net (mtao03.charter.net [209.225.8.188]) by postgresql.org (Postfix) with ESMTP id BC8FA9FB2E8 for ; Fri, 27 Jul 2007 11:33:51 -0300 (ADT) Received: from aa04.charter.net ([10.20.200.156]) by mtao03.charter.net (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20070727143348.YHMI1450.mtao03.charter.net@aa04.charter.net>; Fri, 27 Jul 2007 10:33:48 -0400 Received: from [10.0.1.3] (really [66.188.165.91]) by aa04.charter.net with ESMTP id <20070727143348.LBC1254.aa04.charter.net@[10.0.1.3]>; Fri, 27 Jul 2007 10:33:48 -0400 In-Reply-To: <200707271237.55679.peter_e@gmx.net> References: <05510444-AACD-4FE4-9509-3BC3A4DA4526@seespotcode.net> <200707271237.55679.peter_e@gmx.net> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-docs@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: BIGINT is in apparently SQL:2003 Date: Fri, 27 Jul 2007 09:33:42 -0500 To: Peter Eisentraut X-Mailer: Apple Mail (2.752.2) X-Chzlrs: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/19 X-Sequence-Number: 4346 On Jul 27, 2007, at 5:37 , Peter Eisentraut wrote: > 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. Thanks, Peter. Michael Glaesemann grzm seespotcode net