From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> |
Cc: | "Thomas Lockhart" <lockhart(at)fourpalms(dot)org>, "Barry Lind" <barry(at)xythos(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Implicit coercions need to be reined in |
Date: | 2002-04-16 22:24:49 |
Message-ID: | 29975.1018995889@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> writes:
> Wow, I am completely at a loss why you would not allow implicit coercions
> that do not loose any data in the process.
Haven't you read the previous threads? Implicit coercions are
dangerous, because they cause the system to resolve operators in
unexpected ways. See, eg, bug #484:
http://archives.postgresql.org/pgsql-bugs/2001-10/msg00103.php
http://archives.postgresql.org/pgsql-bugs/2001-10/msg00108.php
I'm not by any means opposed to *all* implicit coercions, but
cross-type-category ones strike me as bad news.
In particular, if all datatypes have implicit coercions to text then
type checking is pretty much a thing of the past :-( ... the system will
be able to resolve nearly anything by interpreting it as a text
operation. See above bug.
I suspect you are going to argue that you are prepared to live with such
misbehavior because it's too darn convenient not to have to write
::text. Well, maybe that is indeed the community consensus, but I want
to see a discussion about it first. And in any case I want a fairly
well-defined, circumscribed policy about which implicit coercions we
will have.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-04-16 22:33:10 | Re: Operators and schemas |
Previous Message | Bruce Momjian | 2002-04-16 21:27:21 | Re: [PATCHES] WITH DELIMITERS in COPY |