AW: Please advise features in 7.1 (SUMMARY) - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Please advise features in 7.1 (SUMMARY)
Date
Msg-id 11C1E6749A55D411A9670001FA687963368150@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List 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


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Problem in AlterTableAddConstraint?
Next
From: "Mitch Vincent"
Date:
Subject: Re: Please advise features in 7.1 (SUMMARY)