Math Operations - DB or App? - Mailing list pgsql-novice

From
Subject Math Operations - DB or App?
Date
Msg-id 20060509194449.21692.qmail@web33306.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Math Operations - DB or App?
List pgsql-novice
i'm in the process of developing some reports for an
application i'm developing.

i'm curious how the more experienced developers do
their math operations.  do you do it in your select or
do you do it in your app?

i can't give an example within a select (that's what
i'm researching next).

an example of doing the math in the app (php) would be
getting a value $p for number of passed units and a
value $t for total units and then setting yield to $y
= $t/$p.

what do you do and why?  what are the pluses and
minuses of each approach?

as always, tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: No quoting in copy CSV mode
Next
From:
Date:
Subject: Math Query Help