Conditional statements - Mailing list pgsql-general

From Mark Alliban
Subject Conditional statements
Date
Msg-id 003a01c01caf$5d73f970$642630d5@teledome.com
Whole thread Raw
List pgsql-general
Hi,

I was wondering if it is possible to have conditional statements in
postgres?

For example:
IF NOT EXISTS(SELECT * FROM testtable WHERE id=3)
    INSERT INTO testtable (id) VALUES (3)

TIA,
Mark.



pgsql-general by date:

Previous
From: Denis Perchine
Date:
Subject: Problems inserting data
Next
From: Neil Conway
Date:
Subject: Re: Transaction Manager