Re: insert into a view?

On Mon, May 01, 2006 at 05:23:22PM -0700, Karen Hill wrote:
> Tried it but didn't work.  It gave me a hint though to try triggers.
> Can anyone show me how to do an insert into a view using triggers?

Rules are probably what you're after; the documentation has examples.

http://www.postgresql.org/docs/8.1/interactive/rules.html
http://www.postgresql.org/docs/8.1/interactive/rules-update.html#RULES-UPDATE-VIEWS

--
Michael Fuhr