From: Tom Lane <tgl@sss.pgh.pa.us>
To: Markus Schaber <schabi@logix-tt.com>
Cc: Frank Bax <fbax@sympatico.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Field length ??
Date: Thu, 20 Apr 2006 11:44:25 -0400
Message-ID: <19020.1145547865@sss.pgh.pa.us> (raw)
In-Reply-To: <4447AA89.9060405@logix-tt.com>
References: <20060420060838.46274.qmail@web33403.mail.mud.yahoo.com>
<20060420060838.46274.qmail@web33403.mail.mud.yahoo.com>
<5.2.1.1.0.20060420111921.00a5b920@pop6.sympatico.ca>
<4447AA89.9060405@logix-tt.com>
Markus Schaber <schabi@logix-tt.com> writes:
> Frank Bax wrote:
>> Except that the original fields were neither variable length datatypes,
>> not type text.
> char is a textual type (in opposite to numeric types), and they are
> handled as variable length datatypes internally (even if given a limit).
char(n) *is* a variable-length type, not merely "handled as such",
because the limit N is measured in characters not bytes. To support
variable-length encodings such as UTF8 we have to treat it as variable
length.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, schabi@logix-tt.com, fbax@sympatico.ca
Subject: Re: Field length ??
In-Reply-To: <19020.1145547865@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox