Am Montag, 11. Oktober 2004 15:50 schrieb Tom Lane: > I agree with Michael's position. I don't like implicit/automatic casts > any more than Peter does, but I don't see a strong argument against > providing explicit casts.
I find the chosen mapping to be somewhat arbitrary and artifical. (2::int => '2'::text is not arbitrary in my mind, but 1::int => true is just something a C programmer could make up.) But I'm clearly in the minority here. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match