Hi Costin I am very experienced with MS-SQL and have had very basic training on Oracle and both of these raise an exception as well. I would suggest that a RDBMS that automatically converts to null is way off the standards. Craig ----- Original Message ----- From: "Costin Manda" <siderite@xxxxxxxxx> To: <pgsql-general@xxxxxxxxxxxxxx> Sent: Saturday, April 16, 2005 9:15 AM Subject: Division by zero > > In other SQL programs a division by zero is solved by transforming the > result to NULL. How can I make postgres have the same behaviour without > using CASE ? > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly