Re: Possible bug?

Peter Eisentraut <peter_e@gmx.net> writes:
> Am Donnerstag, 1. Juli 2004 23:10 schrieb Tom Lane:
>> Right.  The reason PG doesn't error is that we have an implicit cast
>> from integer to text.  I've opined before that we should mark most
>> cross-type-category casts as explicit-only ... they are just too prone
>> to give unexpected answers, as in this case.

> It seems we're just opining in circles.  Why not do it?  Is anyone objecting?

IIRC there were objections the last time it was seriously proposed,
basically of the form "but that will break my application which relies
on writing so-and-so without a cast".  We did get as far as removing all
the implicit cross-category coercions except these casts to text:

 bigint                      | text
 smallint                    | text
 integer                     | text
 real                        | text
 double precision            | text
 numeric                     | text
 oid                         | text
 date                        | text
 time without time zone      | text
 time with time zone         | text
 timestamp without time zone | text
 timestamp with time zone    | text
 interval                    | text

but these seem to have a constituency :-(

            regards, tom lane