Re: [SQL] Doing a conditional insert/update

2007-04-19 Thread Rodrigo De León
On 4/19/07, Markus Holzer <[EMAIL PROTECTED]> wrote: Hello. I'm currently developing my first web app with Postgres and I have a question. How do I perform a conditional insert/update? To clarify: I need to insert data into a table when the primary key is not already in the table, or an update

Re: [SQL] Doing a conditional insert/update

2007-04-19 Thread Andrew Sullivan
On Thu, Apr 19, 2007 at 08:27:30PM +0200, Markus Holzer wrote: > How do I perform a conditional insert/update? The short answer is that you can't, at least not the way you want to. > already in the table, or an update if it is. I have currently solved this by > SELECTing for the primary key, then

[SQL] Doing a conditional insert/update

2007-04-19 Thread Markus Holzer
Hello. I'm currently developing my first web app with Postgres and I have a question. How do I perform a conditional insert/update? To clarify: I need to insert data into a table when the primary key is not already in the table, or an update if it is. I have currently solved this by SELECTing f