Thread: Truncation of char, varchar, bit, varbit types

Truncation of char, varchar, bit, varbit types

From
Peter Eisentraut
Date:
I've sent this a few weeks ago and got support, I just wanted to issue the
final call.

SQL and Postgres differ in behaviour if the value of a char or varchar
type exceeds the declared length.  Postgres cuts off the value, SQL
requires to raise an error.

In particular, the compliant behaviour is:

create table test (a varchar(4));

insert into test values ('ok');
[ok]
insert into test values ('not ok');
ERROR:  value too long for type character varying(4)
insert into test values ('good    ');
[truncates spaces that are too long]

I think this behaviour is desirable over the old one because it makes the
char and varchar types useful in the first place.

For bit types there is, of course, no such extra rule for spaces.
However, SQL requires that for fixed-width bit strings, the input value
must have as many digits as the declared length of the string.  That is,

create table test (a bit(4));
insert into test values (b'101');

will fail.  I think that's reasonable, too, because it avoids the
endianness issues.

Unless there are objections, I will make this happen.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter