is it possible to store results of aggregate calculations in table fields?

From: Jude DaShiell <jdashiel(at)panix(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: is it possible to store results of aggregate calculations in table fields?
Date: 2014-10-13 20:49:28
Message-ID: alpine.NEB.2.00.1410131640100.5251@panix3.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

If I can do that and use table field values to do calculations once moved
it won't be necessary for me to use plr. Earlier I tried:
max_cystalic_pressure int NOT NULL, default max(cystalic_pressure),
and psql won't create the table complaining about default and DEFAULT and
def_EXPR I intended to be max(cystalic_pressure).
Unfortunately Linux command line environment hasn't got anything able to
compete with excel in terms of excel's functions which is why I tried this
database system at all. I hope I do not have to use Windows to get this
done.

--

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel Staal 2014-10-13 21:53:10 Re: is it possible to store results of aggregate calculations in table fields?
Previous Message Benoit Izac 2014-10-10 19:13:14 Re: Picking 25 samples of every domain