Re: getting around---division by zero on numeric - Mailing list 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.