Howto "insert or update" ?

Поиск
Список
Период
Сортировка
Искать
От
Andreas
Тема
Howto "insert or update" ?
Дата
Msg-id
4CEB38B0.8050901@gmx.net
Список
Дерево обсуждения
Howto "insert or update" ? Andreas <maps.on@gmx.net>
Re: Howto "insert or update" ? tv@fuzzy.cz
Hi,
is there an elegant way to tell PG :

a)   Hey PG, look here are e.g. 3 values  A, B, c  for tableX
b)   please check if there is a row matching  A and B  as key in tableX
c)   if such a row exists, execute an UPDATE on column c else INSERT a 
new row.

Currently I have a trigger function that should store a value in tableX 
whenever a certain column in tableY gets changed.
I do it with:
a)   delete from tableX where key = ( A, B )  ( regardless if there is one )
b)   insert into tableX

This seems not very efficient though it works.
Is there a better way?

В списке pgsql-sql по дате отправления
От: Dmitriy Igrishin
Дата:
От: tv@fuzzy.cz
Дата:
Сообщение: Re: Howto "insert or update" ?
FAQ