Update View - Mailing list pgsql-general

From Ryan C. Bonham
Subject Update View
Date
Msg-id 19AB8F9FA07FB0409732402B4817D75A038B76@FILESERVER.SRF.srfarms.com
Whole thread Raw
List pgsql-general
Hi,

Ok i know this has been asked before, and i have read some stuff in the
arcives, but i am jsut getting more confused... Would someone please provide
me with an example on how to right an update rule for the following view.

SELECT table1.initials, table1.trackingnumber, table1.confirm,
table1.checked, table1.notes, table1.part, table1.date, table2.location
FROM (table2 JOIN table1 ON ((table2.part = table2.part)))
ORDER BY table1.date;

Thank you


Ryan C. Bonham

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE
Next
From: Jon Lapham
Date:
Subject: Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE