Re: Strict-typing benefits/costs - Mailing list pgsql-general

From Ken Johanson
Subject Re: Strict-typing benefits/costs
Date
Msg-id 47B61B5F.90008@kensystem.com
Whole thread Raw
In response to Re: Strict-typing benefits/costs  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
Jeff Davis wrote:
> If postgresql were to revert to 8.2 implicit casting behavior, would
> that actually improve compatibility with other DBMSs? Every DBMS
> probably has it's own rules for implicit casting, different from every
> other DBMS.
>
> So are you sure it wouldn't just introduce more compatibility problems
> somewhere else? Or worse, it could hide the problems during
> migration/testing, and they could surface after you put it into
> production.

In my opinion the autocasting behaviors of the database are probably
more consistent and fined tuned, than their explicit cast function. Or
in the least, they may actually *save* mistakes that (lay) programmers
would make (by adding casts for the sake of PG).



pgsql-general by date:

Previous
From: Keith Haugh
Date:
Subject: PL/PGSql function within a view definition
Next
From: Ken Johanson
Date:
Subject: Re: Strict-typing benefits/costs