Re: About Div
| От | Aaron Bono |
|---|---|
| Тема | Re: About Div |
| Дата | |
| Msg-id | bf05e51c0607260749u43e2104di1d6aa9bd7c90bd86@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: About Div (Otniel Michael <otmic_ie@yahoo.com>) |
| Список | pgsql-sql |
On 7/25/06, Otniel Michael <otmic_ie@yahoo.com> wrote:
I think you misunderstood how to use the MOD value. 10 % 7 = 3 so the last 3 people get 1 extra, NOT the last person getting the extra 3.
But it looks like Ross got you the code to fix the problem. Check what he provided.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
Mr. Aaron. I am sorry, your solution didn't match in my case.
Example for your solution :
A = 1
B = 1
C = 1
D = 1
E = 1
F = 1
G = 4
G have 4 candy. Its too much for G.
In my case, the solution is :
A = 1
B = 1
C = 1
D = 1
E = 2
F = 2
G = 2
The extra candy is given to three child.
Do you have the other solution? I need function in postgresql for my case.
Because my loop is too slow.
Btw thanks for your solution.
But it looks like Ross got you the code to fix the problem. Check what he provided.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
В списке pgsql-sql по дате отправления: