Postgres Pro
Downloads
Home   >   mailing lists

Testing for a record before update or insert without using a function. - Mailing list pgsql-admin

From Geoff Ellis
Subject Testing for a record before update or insert without using a function.
Date
Msg-id 006401c37dea$8656ca80$af1dc9c2@goofelvis
Whole thread Raw
Responses Re: Testing for a record before update or insert without using a function.  ("Chris White (cjwhite)" <cjwhite@cisco.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Jaskier"
Date:
Subject: Re: initdb problem
Next
From: Rhaoni Chiu Pereira
Date:
Subject: Re: [PERFORM] How to force an Index ?