| From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
|---|---|
| To: | "'Ross J(dot) Reedstrom'" <reedstrm(at)rice(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | AW: Please advise features in 7.1 (SUMMARY) |
| Date: | 2000-11-28 15:50:59 |
| Message-ID: | 11C1E6749A55D411A9670001FA687963368150@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > This is a summary of replies.
> >
> > 1. Calculated fields in table definitions . eg.
> >
> > Create table test (
> > A Integer,
> > B integer,
> > the_sum As (A+B),
> > );
> >
> > This functionality can be achieved through the use of views.
>
> Using a view for this isn't quite the same functionality as a computed
> field, from what I understand, since the calculation will be done at
> SELECT time, rather than INSERT/UPDATE.
I would expect the calculated field from above example to be calculated
during select time also, no ? You don't want to waste disk space with something
you can easily compute at runtime.
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-11-28 16:14:59 | Re: FWD: tinterval vs interval on pgsql-novice |
| Previous Message | Thomas Lockhart | 2000-11-28 15:49:36 | Re: beta testing version |