SEO

#1 (**permalink**) 04-09-2008, 09:01 AM

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

#2 (**permalink**) 04-09-2008, 09:04 AM

No, but you should be able to build something similar using a
language that understands XML. You could then pass something like
this to the database:

SELECT updategram.update('big-ole XML string');

If you wanted to get even more fancy, you could create a daemon that
would accept connections as if it was a postmaster and handle in-line
XML requests however MS does.

If you decide to go this route please consider starting a project on
pgFoundry, as I'm sure others would find this useful.

On Mar 29, 2006, at 2:08 AM, SunWuKung wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--
Jim C. Nasby, Database Architect decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

updategram in pg