Conditional statements

From: "Mark Alliban" <MarkA(at)idnltd(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Conditional statements
Date: 2000-09-12 11:48:26
Message-ID: 003a01c01caf$5d73f970$642630d5@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?

For 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 Jeff MacDonald 2000-09-12 15:02:09 MySQL benchmarks updated to PostgreSQL 7.0.2 (fwd)
Previous Message Neil Conway 2000-09-12 11:19:04 Re: Transaction Manager