From: | Alexander Pucher <pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Sum of two rows |
Date: | 2003-03-10 10:02:33 |
Message-ID: | 3E6C62B9.2070908@atlas.gis.univie.ac.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
this might be an obvious thing, but still I'm biting on this for some time:
Let's pretend I want to have a table with 3 columns.
The first and second should each hold an integer value, the third should
hold the sum of column1 + column2 as an integer.
The idea behind this table should be that the sum is automatically
updated, each time I change one of the values in either of the first two
columns.
Best regards,
alex
--
________________________________________________________
Institut fuer Geographie und Regionalforschung
Universitaet Wien
Kartografie und Geoinformation
Departement of Geography and Regional Research
University of Vienna
Cartography and GIS
Universitaetstr. 7, A-1010 Wien, AUSTRIA
Tel: (+43 1) 4277 48644
Fax: (+43 1) 4277 48649
E-mail: alexander(dot)pucher(at)univie(dot)ac(dot)at
FTP: ftp://ftp.gis.univie.ac.at
WWW: http://www.gis.univie.ac.at/karto
--------------------------------------------------------
Virtual Map Forum: http://www.gis.univie.ac.at/vmf
--------------------------------------------------------
It's not that I'm afraid to die,
I just don't want to be there when it happens -- Woody Allen
From | Date | Subject | |
---|---|---|---|
Next Message | cristi | 2003-03-10 11:29:28 | export from postgres into dbf |
Previous Message | Manfred Koizar | 2003-03-10 09:25:27 | Re: Sum of two rows |