Updating & inserting in one shot!

nearly ready to use
replace (int4, text, "timestamp") with your fieldtypes; its convention:
first param is primary key

replace
update bcachekredbetr set
betreuer=$2, letztespeicherung=$3
where id_p=$1;
with the appropriate update (where clause -> references primary key)

CREATE OR REPLACE FUNCTION uoibcachekredbetr(int4, text, "timestamp")
RETURNS int4 AS
$BODY$
DECLARE
result int4;
BEGIN
update bcachekredbetr set
betreuer=$2, letztespeicherung=$3
where id_p=$1;

IF FOUND THEN
result:=-1;
else
insert into bcachekredbetr (
id_p, betreuer, letztespeicherung
)
values ($1, $2, $3);
result:=$1;
END IF;
RETURN result;

END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

hth,

Harald

On 4/10/06, Vittorio <vdemart1@tin.it> wrote:

In my Postgresql 8.06 db I have a table in which the key fields are a
date and a code.

Now I need to load data from a text file (or a
temporary table) that either should update OR should be insert-ed into
that table.

Is there any ready-to-use, contributed function allowing
this 1-shot update-insert into a table?

Ciao
Vittorio

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
PostgreSQL - supported by a community that does not put you on hold