Conditional statements?

From: "Mark Alliban" <MarkA(at)idnltd(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Conditional statements?
Date: 2000-09-18 13:29:02
Message-ID: 002a01c02174$69b5f7f0$0e0410ac@teledome.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Erich Cadario 2000-09-18 13:47:13 SQL-Error
Previous Message Sergio A. Kessler 2000-09-18 12:30:00 Re: windows UI tool???