Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3AFtP877384 for ; Tue, 10 Apr 2001 11:55:25 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f3AFWlL27842 for pgsql-hackers@postgresql.org; Tue, 10 Apr 2001 11:32:47 -0400 (EDT) (envelope-from news) From: Alessio Bragadini X-Newsgroups: comp.databases.postgresql.hackers Subject: Re: AW: Truncation of char, varchar types Date: Tue, 10 Apr 2001 16:32:52 +0300 Organization: APL Financial Services Overseas Ltd. Lines: 16 Message-ID: <3AD30B84.B49470AA@albourne.com> References: <11C1E6749A55D411A9670001FA68796336827F@sdexcsrv1.f000.d0188.sd.spardat.at> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.18pre21 i686) X-Accept-Language: it, en To: pgsql-hackers@postgresql.org X-Archive-Number: 200104/338 X-Sequence-Number: 7319 Zeugswetter Andreas SB wrote: > Yes, iirc the only thing you are allowed to do is issue a warning, > but the truncation is allowed and must succeed. > (checked in Informix and Oracle) ? As much as I remember, Oracle raises an error. But it's been a few years since I last touched it, so maybe I'm wrong. -- Alessio F. Bragadini alessio@albourne.com APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-2-755750 "It is more complicated than you think" -- The Eighth Networking Truth from RFC 1925