| From: | "Ryan C(dot) Bonham" <Ryan(at)srfarms(dot)com> |
|---|---|
| To: | "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Update View |
| Date: | 2001-10-09 14:59:30 |
| Message-ID: | 19AB8F9FA07FB0409732402B4817D75A038B76@FILESERVER.SRF.srfarms.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jon Lapham | 2001-10-09 15:05:05 | Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE |
| Previous Message | news.optonline.net | 2001-10-09 14:54:27 | Re: How to make a REALLY FAST db server? |