Received: from ncc1701.cistron.net (ncc1701.cistron.net [195.64.68.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4ND4jA55437 for ; Wed, 23 May 2001 09:04:45 -0400 (EDT) (envelope-from news@uucp.cistron.nl) Received: from news by ncc1701.cistron.net with local (Exim 3.20 #1 (Debian)) id 152YJY-00076z-00 for ; Wed, 23 May 2001 15:04:36 +0200 From: jdassen@cistron.nl (J.H.M. Dassen (Ray)) Subject: Re: Truncation of char, varchar, bit, varbit types (fwd) Date: Wed, 23 May 2001 13:04:36 +0000 (UTC) Organization: Cistron Internet Services B.V. Lines: 18 Message-ID: References: X-Trace: ncc1701.cistron.net 990623076 25365 195.64.65.236 (23 May 2001 13:04:36 GMT) X-Complaints-To: abuse@cistron.nl To: pgsql-sql@postgresql.org Errors-To: <> X-Archive-Number: 200105/248 X-Sequence-Number: 3076 Peter Eisentraut wrote: > 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: > I think this behaviour is desirable over the old one because it makes the > char and varchar types useful in the first place. AOL! (Although to ease migration, it would be nice if one could switch between treating it as an error or a warning for the next few releases). Ray -- USDoJ/Judge Jackson: "Microsoft has performed an illegal operation and will be shut down." James Turinsky in alt.sysadmin.recovery