X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C28E111F6077 for ; Thu, 20 Apr 2006 12:30:38 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.096 X-Spam-Level: X-Spam-Status: No, score=0.096 required=5 tests=[AWL=0.096] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id bY0fJ2NNHmFe for ; Thu, 20 Apr 2006 12:30:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from tomts36-srv.bellnexxia.net (tomts36.bellnexxia.net [209.226.175.93]) by postgresql.org (Postfix) with ESMTP id D54B411F6057 for ; Thu, 20 Apr 2006 12:30:32 -0300 (ADT) Received: from acer.sympatico.ca ([65.95.176.171]) by tomts36-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with ESMTP id <20060420153031.FZBO13653.tomts36-srv.bellnexxia.net@acer.sympatico.ca> for ; Thu, 20 Apr 2006 11:30:31 -0400 Message-Id: <5.2.1.1.0.20060420111921.00a5b920@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Thu, 20 Apr 2006 11:21:27 -0400 To: pgsql-sql@postgresql.org From: Frank Bax Subject: Re: Field length ?? In-Reply-To: <4447515C.5070601@logix-tt.com> References: <20060420060838.46274.qmail@web33403.mail.mud.yahoo.com> <20060420060838.46274.qmail@web33403.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200604/140 X-Sequence-Number: 24949 At 05:16 AM 4/20/06, Markus Schaber wrote: >Hi, Louise, > >Louise Catherine wrote: > > > Could anyone explain, why the field length must be add by 4 : > > result 1 : 10 + 4 =14 > > result 2 : 5 + 4 = 9 > >I guess that it is because all variable length datatypes (and text types >are such) internally contain a 4 bytes length field. Except that the original fields were neither variable length datatypes, not type text. create table test(] satu char(10), dua char(5) );