updategram in pg - Mailing list pgsql-general

From SunWuKung
Subject updategram in pg
Date
Msg-id MPG.1e945f005d351a2e989696@news.postgresql.org
Whole thread Raw
Responses Re: updategram in pg  (Jim Nasby <decibel@decibel.org>)
List pgsql-general
Is there a way to store update/insert logic in the data instead of
writing db or application procedures to do that?

I am looking for something along the lines of MS updategrams like this:

<ROOT xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
 <updg:sync>
  <updg:before></updg:before>
  <updg:after updg:returnid="x y" >
       <HumanResources.Shift updg:at-identity="x" Name="Day-Evening"
                        StartTime="1900-01-01 11:00:00.000"
                        EndTime="1900-01-01 19:00:00.000"
                        ModifiedDate="2004-01-01 00:00:00.000" />
       <HumanResources.Shift updg:at-identity="y" Name="Evening-Night"
                        StartTime="1900-01-01 19:00:00.000"
                        EndTime="1900-01-01 03:00:00.000"
                        ModifiedDate="2004-01-01 00:00:00.000" />
  </updg:after>
 </updg:sync>
</ROOT>

Thanks for the help.
Balázs

pgsql-general by date:

Previous
From: "Tobias Herp"
Date:
Subject: using types for encrypting fields
Next
From: Achilleus Mantzios
Date:
Subject: Flight numbers data