Postgres Pro
Downloads
Home   >   mailing lists

Re: Updatable view does not work [oops, quite long!] - Mailing list pgsql-novice

From Thiemo Kellner
Subject Re: Updatable view does not work [oops, quite long!]
Date
Msg-id 3EDFB81B.2000700@thiam.ch
Whole thread Raw
In response to Re: Updatable view does not work [oops, quite long!]  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-novice
Tree view 
Manfred Koizar wrote:
> You need somethink bulky like
>     pwd.link = old.link OR (pwd.link IS NULL AND old.link IS NULL)

I choose this solution. So I can hide the technical PK from the user.
Thanks for the hint. Works perfectly.

Tschau,

Thiemo

--
root ist die Wurzel allen Übels

pgsql-novice by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: Question regarding keyword checkboxes in database design
Next
From: Paul Makepeace
Date:
Subject: [bug?] oddity creating table with uppercase initial