From: | "Craig Bryden" <postgresql(at)bryden(dot)co(dot)za> |
---|---|
To: | "Costin Manda" <siderite(at)madnet(dot)ro>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Division by zero |
Date: | 2005-04-16 11:14:37 |
Message-ID: | 001301c54275$7c2abe30$0200a8c0@amd2800 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)madnet(dot)ro>
To: <pgsql-general(at)postgresql(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2005-04-16 14:07:53 | Re: pgpool with PostgreSQL 7.4 |
Previous Message | Michael Fuhr | 2005-04-16 09:05:11 | Re: Division by zero |