On Mar 3, 2021, at 11:55 AM, Allan Biggs <allanb4@iname.com> wrote:
Also sent to the OpenROAD group
I have spent the day wishing that I could update a view.
On Mar 3, 2021, at 11:55 AM, Allan Biggs <allanb4@iname.com> wrote:
Also sent to the OpenROAD group
I have spent the day wishing that I could update a view.
You can update a simple view that is just select columns from a table, and
I think a where clause is allowed.
The Standard allows updating a more general view, with a whole slew
of rules and regulations about what you can and can't update; but Ingres
has never bothered to implement it.
On Mar 3, 2021, at 12:50 PM, Roy Hann <specially@processed.almost.meat> wrote:
...
Incidentally, in 2013 Chris Date wrote an entire book (largely
unhindered by any thoughts of SQL): View Updating and Relational
Theory, ISBN 978-1-449-35784-9. I see the bookmark in my copy is well
over a quarter of the way through it...
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (2 / 14) |
Uptime: | 22:43:19 |
Calls: | 8,766 |
Calls today: | 9 |
Files: | 13,287 |
D/L today: |
3 files (1,633K bytes) |
Messages: | 5,964,755 |