Re: [GENERAL] Updating & inserting in one shot!

2006-04-10 Thread Harald Armin Massa
nearly ready to usereplace (int4, text, "timestamp") with your fieldtypes; its convention: first param is primary keyreplace    update bcachekredbetr set     betreuer=$2, letztespeicherung=$3     where id_p=$1; with the appropriate update (where clause -> references prim

[GENERAL] Updating & inserting in one shot!

2006-04-10 Thread Vittorio
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-