Testing for a record before update or insert without using a function.

From: "Geoff Ellis" <geoff(at)metalogicplc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Testing for a record before update or insert without using a function.
Date: 2003-09-18 13:41:09
Message-ID: 006401c37dea$8656ca80$af1dc9c2@goofelvis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is it possible to test if a record exists in a table and then if it does do
an update on that table or if it doesn't do an insert ? I've looked around
the documents and it seems everything points towards a function?

Is this the only way or has someone done this before.....

TIA

Geoff

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rhaoni Chiu Pereira 2003-09-18 14:45:09 Re: [PERFORM] How to force an Index ?
Previous Message Jaskier 2003-09-18 13:25:52 Re: initdb problem