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.
http://www.postgresql.org/docs/8.1/interactive/xtypes.html might be a
start if you want to read more on this topic.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org