views and rules
| От | Nick Haw |
|---|---|
| Тема | views and rules |
| Дата | |
| Msg-id | 71F468541618D3118DDF204C4F4F5020775D96@MAPSERVER обсуждение исходный текст |
| Список | pgsql-general |
I have created the view below, I want people to only be able to update 2 fields (fldpaid and fldpaiddate) in the view. How do I go about doing this? Many thanks Nick Haw CREATE VIEW "vw_invoicerestricted" AS SELECT tblinvoice.fldinvoicenumber, tblinvoice.fldinvoicedate, tblinvoice.fldinvoicecompany, tblinvoice.fldinvoiceclient, tblinvoice.fldsurveynumber, tblinvoice.fldtheirref, tblinvoice.flddescription, tblinvoice.fldchargevat, tblinvoice.fldcompany, tblinvoice.flddivision, tblinvoice.fldpaid, tblinvoice.fldpaiddate, tblinvoice.fldcreditnote, tblinvoice.fldinternalinvoice, tblinvoice.fldoldinvoicecompany, tblinvoice.fldoldinvoiceclient, tblinvoice.flddateadded, tblinvoice.flduseradded, tblinvoice.flddatemodified, tblinvoice.fldusermodified FROM tblinvoice WHERE (tblinvoice.fldcreditnote = 0)
В списке pgsql-general по дате отправления: