AW: AW: AW: Truncation of char, varchar types

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: AW: AW: Truncation of char, varchar types
Date: 2001-04-12 08:24:01
Message-ID: 11C1E6749A55D411A9670001FA687963368285@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> > Thank you. Is an "exception condition" necessarily an error, or
> > is a warning also an exception condition ?
>
> A warning/notice is called a "completion condition".
>
> > Because other db's only raise a warning. Of course we don't want to
> > copy that behavior if they are not conformant. See above question.
>
> Someone said Oracle raises an error.

Yes, I am very sorry.

> Informix seems to be the only other db that truncates silently.

Raises a warning instead of error. Would need to check Sybase and DB2, but ...

> I think Oracle wins here...

Yes, good. Do we want this in 7.1.0 ? Seems, yes :-(

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2001-04-12 12:43:50 Re: AW: AW: AW: Truncation of char, varchar types
Previous Message Nathan Myers 2001-04-12 07:53:56 Re: Re: Hand written parsers