Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!csd4.milw.wisc.edu!dogie.macc.wisc.edu!uwvax!ai!beverly From: beverly@ai.cs.wisc.edu (Beverly Seavey) Newsgroups: comp.databases Subject: Update in INGRES via view Message-ID: <7501@spool.cs.wisc.edu> Date: 10 May 89 15:29:49 GMT Sender: news@spool.cs.wisc.edu Reply-To: beverly@ai.cs.wisc.edu (Beverly Seavey) Organization: U of Wisconsin CS Dept Lines: 8 Is it possible to do updates in INGRES via views? The situation is that I have assigned numbers to atoms in amino acids. The numbers are sort of unfriendly, but the names of the atoms would take up much more storage. I would like to be able to set up forms that accept and show atom names in the field, but actual storage would be using the more efficient numbers. I also need to know this for ORACLE.