INSERT or UPDATE

From: Andreas Kraftl <andreas(dot)kraftl(at)kraftl(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: INSERT or UPDATE
Date: 2008-08-18 07:44:48
Message-ID: 1219045488.7792.9.camel@zeus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello

I have an XML file, which i must import into the database. I transform
this XML File with xslt to sql INSERTS.

But there is also the possibility, that one row is available. Means that
i need an UPDATE instead of the INSERT.

Is it in SQL possible to decide if there is an UPDATE or an INSERT or
must i program something with PHP for example?

Thanks
Andreas

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2008-08-18 10:50:28 Re: INSERT or UPDATE
Previous Message Xavier Bermeo 2008-08-16 19:35:55 Cursor