|PostgreSQL Reference Manual - Volume 2 - Programming Guide|
by The PostgreSQL Global Development Group
Paperback (6"x9"), 408 pages
RRP £19.95 ($34.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
7.2.4 Updating a View
What happens if a view is named as the target relation for an
DELETE? After doing the substitutions
described above, we will have a query tree in which the result
relation points at a subquery range-table entry. This will not
work, so the rewriter throws an error if it sees it has produced
such a thing.
To change this, we can define rules that modify the behavior of these kinds of commands. This is the topic of the next section.
|ISBN 0954612035||PostgreSQL Reference Manual - Volume 2 - Programming Guide||See the print edition|