Re: Division by zero
| От | Craig Bryden |
|---|---|
| Тема | Re: Division by zero |
| Дата | |
| Msg-id | 001301c54275$7c2abe30$0200a8c0@amd2800 обсуждение исходный текст |
| Ответ на | Admin Tool to Send Me Email ("Garris, Nicole" <Nicole.Garris@dof.ca.gov>) |
| Список | pgsql-general |
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@madnet.ro> To: <pgsql-general@postgresql.org> Sent: Saturday, April 16, 2005 9:15 AM Subject: [GENERAL] 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 > >
В списке pgsql-general по дате отправления: