Update View

Поиск
Список
Период
Сортировка
От Ryan C. Bonham
Тема Update View
Дата
Msg-id 19AB8F9FA07FB0409732402B4817D75A038B76@FILESERVER.SRF.srfarms.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE
Следующее
От: Jon Lapham
Дата:
Сообщение: Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE