Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [HACKERS] MERGE-esque Functionallity (was: Adding MERGE to the TODO list (resend with subject))
- From: Mike Rylander <miker(at)purplefrog(dot)com>
- To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
- Cc: <pgsql-general(at)postgresql(dot)org>, "postgres SQL" <pgsql-sql(at)postgresql(dot)org>
- Subject: Re: [HACKERS] MERGE-esque Functionallity (was: Adding MERGE to the TODO list (resend with subject))
- Date: Fri, 14 May 2004 14:04:20 -0400
- Message-id: <200405141402.07429.miker@purplefrog.com> <text/plain>
On Tuesday 11 May 2004 09:44 am, Bruce Momjian wrote: [snip] > > > > Bruce Momjian kirjutas E, 10.05.2004 kell 06:58: > > > > > Added to TODO: > > > > > > > > > > * Add MERGE command that does UPDATE, or on failure, INSERT > > > > [snip] Hello all. I have been lurking here for a bit and the MERGE topic (on [HACKERS]) caught my eye, so I had a go at implementing a basic version of MERGE-on-INSERT in pl/pgsql. It is attached below, and any comments are welcome. I find it useful on "status" type tables, though it is not very nice when there are many clients (table locking to avoid race conditions). Hope someone will find it useful! -miker
Attachment:
merge_on_insert.sql
Description: Text Data
- Prev by Date: view running query
- Next by Date: Re: where is this problem (trigger)
- Previous by thread: Re: Multiple outer join on same table
- Next by thread: Re: How to speed up a time dimension query
- Indexes: