Re: Division by zero - Mailing list pgsql-general

From Craig Bryden
Subject Re: Division by zero
Date
Msg-id 001301c54275$7c2abe30$0200a8c0@amd2800
Whole thread Raw
In response to Admin Tool to Send Me Email  ("Garris, Nicole" <Nicole.Garris@dof.ca.gov>)
List 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 by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Division by zero
Next
From: Tatsuo Ishii
Date:
Subject: Re: pgpool with PostgreSQL 7.4