On 15 May 2016, at 4:08pm, Jean-Luc Hainaut <jean-luc.hainaut at unamur.be> 
wrote:

> - A computed column can be maintained through appropriate triggers (here, "on 
> insert" and "on update"). Efficient if you read data more than you modify 
> them.

Hmm.  Yes, you're right.  Your way of simulating it is better than my way of 
simulating it.  It just needs triggers on INSERT and UPDATE, and I can create 
an index on the table itself and I don't need a view.  That's neat.  Thanks.

Simon.

Reply via email to