Re: Casting, again

Your pg_excelencies,

Peter Eisentraut wrote:

> I would go as far as saying that if you try to insert a 5 in a text field
> then this should be an error, you must write '5'. Surely some might claim
> that this is an inconvenience. Indeed, this is inconveniencing me because
> possible errors in string processing or even system logic are silently
> dropped under the table. Nobody ever got carpal tunnel syndrome because of
> two extra quotes, and if the SQL is machine-generated then fixing the
> program is the best thing in the long run anyway.

Did you think to a system with some abstract types (like numeric, char, date,
etc.) and fizical
types within the abstract types (i.e. abstract numeric type holds physical
integer type, physical
float type, phisical numeric type), and the only implicit cast that parser
does to be
between phisical types whithin the same abstract type ?

Raul.