Re: maths functions and spreadsheet - Mailing list pgsql-novice

From Andrej Ricnik-Bay
Subject Re: maths functions and spreadsheet
Date
Msg-id b35603930801281827ya78f3b3oc663cabc7a6b326@mail.gmail.com
Whole thread Raw
In response to maths functions and spreadsheet  (e-letter <inpost@gmail.com>)
List pgsql-novice
On 29/01/2008, e-letter <inpost@gmail.com> wrote:
> I want to store data in a database. Do I have to perform mathematical
> functions within the database, or can I use a spreadsheet (e.g. calc)?

It depends.

> sum=((database 1 table 1, row 2 colum 3)*(spreadsheet cell
> a1)/(database 2 table 2, row 3 column 4))-exp (spreadsheet cell b2))

My immediate question here would be:
"how do you assure that structure with the information stored within
a database?"

> Or must I perform all computations in the database and then create
> some sort of report to display the results?

That's another option, but this can't be answered w/o knowledge of
a use-case.  One nifty thing you may want to look into *if* you go
with the "calculation within database" solution would be pl/R, which
should enable you to output postscript graphs of your results as
a report ....


> Yours,
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: maths functions and spreadsheet
Next
From: Tom Lane
Date:
Subject: Re: Update from other tables slow