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

[Berend Tober <btober@xxxxxxxxxxxxxxxx>]

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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org