Math Operations - DB or App?

From: <operationsengineer1(at)yahoo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Math Operations - DB or App?
Date: 2006-05-09 19:44:49
Message-ID: 20060509194449.21692.qmail@web33306.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2006-05-09 20:59:36 Math Query Help
Previous Message Sean Davis 2006-05-09 11:50:16 No quoting in copy CSV mode