AW: AW: AW: Truncation of char, varchar types - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: AW: AW: Truncation of char, varchar types
Date
Msg-id 11C1E6749A55D411A9670001FA687963368285@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: AW: AW: Truncation of char, varchar types
List 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


pgsql-hackers by date:

Previous
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: Re: Hand written parsers
Next
From: Alessio Bragadini
Date:
Subject: Re: age() function documentation