Postgres Pro
Downloads
Home   >   mailing lists

Conditions in PostGres SQL - Mailing list pgsql-general

From Stephan Richter
Subject Conditions in PostGres SQL
Date
Msg-id 4.3.1.0.20000622165052.00aa0200@198.78.130.6
Whole thread Raw
Responses Re: Conditions in PostGres SQL  ("Robert B. Easter" <reaster@comptechnews.com>)
List pgsql-general
Tree view 
Hello everyone,

I want to do the following SQL statement:

I want to check whether an entry exists. If it does not exist, add an entry
to the table, otherwise update the existing one:

Pseudo code:

IF entry IN table
      UPDATE entry
ELSE
      ADD entry
FI

Does anyone know how to do that?

Regards,
Stephan
--
Stephan Richter
CBU - Physics and Chemistry
Web2k - Web Design/Development & Technical Project Management

pgsql-general by date:

Previous
From: "Robert D. Nelson"
Date:
Subject: RE: PHP Install with Postgres support.
Next
From: Ryan Kirkpatrick
Date:
Subject: Re: Sequences do not obey transactions...