Re: Division by zero

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
>
>

In response to

Browse pgsql-general by date

  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