Conditional statements?

Started by Mark Allibanover 25 years ago1 messagesgeneral
Jump to latest
#1Mark Alliban
MarkA@idnltd.com

Hi,

I was wondering if it is possible to have conditional statements in
postgres, like there are in M$SQL?

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

TIA,
Mark.