pgman(at)candle(dot)pha(dot)pa(dot)us wrote:
>
> The SQL standard required the change.
Can you be more specific? Are we talking about SQL-99 or something beyond
SQL-92? Of course PostgreSQL doesn't fully comply with that standard
(whichever standard it is), so what criteria are used to determine what
parts to comply with? Of course I would prefer selective compliance to pick
features rather than restrictions.
Sorry for the attitude here, but this change did cost me some time to fix
applications which broke at 7.2 because of this, and I didn't enjoy that.
I don't have access to a lot of different databases, but two I tried do
silent truncation into CHAR and VARCHAR. I wonder what Oracle does.