Re: Field length ?? - Mailing list pgsql-sql

From Frank Bax
Subject Re: Field length ??
Date
Msg-id 5.2.1.1.0.20060420111921.00a5b920@pop6.sympatico.ca
Whole thread Raw
In response to Re: Field length ??  (Markus Schaber <schabi@logix-tt.com>)
Responses Re: Field length ??  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-sql
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)        );




pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: ask syntax sql to get length of field
Next
From: Markus Schaber
Date:
Subject: Re: Field length ??