Re: getting around---division by zero on numeric

From: Berend Tober <btober(at)seaworthysys(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: getting around---division by zero on numeric
Date: 2005-10-19 14:17:52
Message-ID: 43565590.4080704@seaworthysys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton wrote:

> Tim Nelson wrote:
>
>> I am getting division by zero on a calculated field ( sum(sales) is 0 )
>
>
> It's a two-stage process, so you'll want a sub-query. Something like: ...

Thanks. That's a cool addition to my bag of tricks.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ledina Hido 2005-10-19 14:25:25 Checking Multiplicity Constraints and Retrieving Data from Error Messages
Previous Message Andrew Sullivan 2005-10-19 14:16:29 Re: [GENERAL] Oracle buys Innobase