switching between insert and update

From: "Travis Hoyt" <thoyt(at)npc(dot)net>
To: "Postgres" <pgsql-novice(at)postgresql(dot)org>
Subject: switching between insert and update
Date: 2002-03-21 13:46:49
Message-ID: DBEMKMGOMJAGKAKEPPEGKEENDFAA.thoyt@npc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Not sure if this is the right list but here goes:

I've got a perl script that inserts some data. Simple enough, but my
problem is that it fails when I try to insert more data that contains the
same time and id. Is there an easy way of switching from an INSERT to an
UPDATE and does anyone know of any examples? There's one more piece to
this puzzle. The columns names and number of columns addressed are
dynamic and will change for each file loaded into the database.

Thanks,

Travis

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2002-03-21 16:04:32 Re: [NOVICE] Conditional constraint?
Previous Message Nick Haw 2002-03-21 10:36:57 Re: [NOVICE] Conditional constraint?