Re: INSERT/UPDATE/DELETE Views

Darko Prenosil wrote:
> On Tuesday 20 May 2003 12:01, Kaarel wrote:
>
>>Hi
>>
>>I'm relatively new to PostgreSQL. I was wondering why were
>>INSERT/UPDATE/DELETE view diabled in PostgreSQL? Other database systems
>>have these features so why shouldn't PostgreSQL. I did some searching
>>and found that prior version 7.1 or 7.0 these features were in fact
>>enabled. I couldn't however find a satisfying reason for the removal of
>>these features from PostqreSQL mailing list archives.
>>
>>
>
> Postgres had, and still have update, delete and insert rules, which can be
> used to "simulate" updatable views. Read documentation ! You can start with
> "CREATE RULE" sql command. It is too much to explain it in one mail.

That "documentation" would be

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=rules.html

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #