> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane > Sent: 03 October 2004 20:39 > To: [EMAIL PROTECTED] > Subject: [HACKERS] Checking for overflow of integer arithmetic > > 2. For the int2 and int8 operators, should we stick to a > one-size-fits-all message "integer out of range", or be more > specific: "smallint out of range" and "bigint out of range"? > The existing messages are not completely consistent about > this. I'm inclined to go with mentioning the specific type > but I'm not dead set on it.
I vote for being more specific. A little extra info can sometimes ease debugging problems no matter how trivial it seems. Regards, Dave. ---------------------------(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