| From: | Nick Haw <nick(dot)haw(at)operagrp(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | views and rules |
| Date: | 2002-06-20 09:03:01 |
| Message-ID: | 71F468541618D3118DDF204C4F4F5020775D96@MAPSERVER |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrik Steffen | 2002-06-20 09:34:08 | Re: Serious Crash last Friday |
| Previous Message | Henrik Steffen | 2002-06-20 07:34:21 | Re: Serious Crash last Friday |