Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXnpZ-0004oX-ID for pgsql-docs@arkaria.postgresql.org; Wed, 09 Apr 2014 08:26:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WXnpZ-0000qj-0j for pgsql-docs@arkaria.postgresql.org; Wed, 09 Apr 2014 08:26:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXnpX-0000oW-HP for pgsql-docs@postgresql.org; Wed, 09 Apr 2014 08:25:59 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXnpU-0003P1-SE for pgsql-docs@postgresql.org; Wed, 09 Apr 2014 08:25:59 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1WXnpU-00031c-Cs; Wed, 09 Apr 2014 04:25:56 -0400 Date: Wed, 9 Apr 2014 04:25:56 -0400 From: Bruce Momjian To: nuko yokohama Cc: pgsql-docs@postgresql.org Subject: Re: interval data type storage size Message-ID: <20140409082556.GH8685@momjian.us> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On Thu, Apr 3, 2014 at 12:58:37PM +0900, nuko yokohama wrote: > Hi, > > PostgreSQL 9.3 document in "Table 8-9" of "8.5. Date / Time Types", storage > size of the interval data type has 12 bytes. > However, the definition of "datatype/timestamp.h", size of the interval data > type was 16 bytes. > In addition, interval data type was 16 bytes even dump the results of the table > file. > "day" field to the interval data type is added in PostgreSQL 8.1, but do not > not been reflected in the document PostgreSQL at that time? The interval data type size will be properly documented in the next minor release. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs