> > 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.
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2000-11-28 16:14:59|
|Subject: Re: FWD: tinterval vs interval on pgsql-novice |
|Previous:||From: Thomas Lockhart||Date: 2000-11-28 15:49:36|
|Subject: Re: beta testing version|