division by zero error in a request - Mailing list pgsql-general

From Bernard Grosperrin
Subject division by zero error in a request
Date
Msg-id wf3mczdcqge1.1vyz19vu3vvi9.dlg@40tude.net
Whole thread Raw
Responses Re: division by zero error in a request
List pgsql-general
I wants to make a view giving me some statistics.

I am not sure to understand why something like this

SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) /
(sold_parts_amount_dly + sold_labor_amount_dly) from sales

give me a division by zero error?

If that is not the way to go, should I write a function that I would call
instead?

Thanks,
Bernard

pgsql-general by date:

Previous
From: "binberati"
Date:
Subject: FastCgi / PostgreSQL: FATAL: Ident authentication failed for user "user_name"
Next
From: Daniel.Chmielewski@gmail.com
Date:
Subject: trigger postgresql 7.4