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

Reply via email to