Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: INSERT OU UPDATE WITHOUT SELECT?
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: PFC <lists(at)peufeu(dot)com>
- Cc: "Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com>, Waldomiro <waldomiro(at)shx(dot)com(dot)br>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: INSERT OU UPDATE WITHOUT SELECT?
- Date: Tue, 30 May 2006 18:38:18 -0400
PFC wrote: > >PostgreSQL does not support MERGE at the moment, sorry. > > Issue an UPDATE, and watch the rowcount ; if the rowcount is 0, > issue an INSERT. > Be prepared to retry if another transaction has inserted the row > meanwhile, though. Oh, you mean, like the example that's in the documentation? http://www.postgresql.org/docs/8.1/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING Example 36-1 > MERGE would be really useful. It has been discussed before -- MERGE is something different. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- References:
- INSERT OU UPDATE WITHOUT SELECT?
- From: Waldomiro
- Re: INSERT OU UPDATE WITHOUT SELECT?
- From: Jonah H. Harris
- Re: INSERT OU UPDATE WITHOUT SELECT?
- From: PFC
- INSERT OU UPDATE WITHOUT SELECT?
- Prev by Date: Re: Optimizing a huge_table/tiny_table join
- Next by Date: Re: INSERT OU UPDATE WITHOUT SELECT?
- Previous by thread: Re: INSERT OU UPDATE WITHOUT SELECT?
- Next by thread: Re: INSERT OU UPDATE WITHOUT SELECT?
- Indexes: