EXISTS

From: Denis Woodbury <denis(at)woodmic(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: EXISTS
Date: 2008-10-11 11:22:09
Message-ID: BLU0-SMTP17A93DCE115F021F7A60FDCB340@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I would like to know if this this type of statement can be used in
Postgresql

IF NOT EXISTS (SELECT 1 FROM Table WHERE col1 = 'mystring' )
BEGIN
...
END

If it can, any idea why I get this error.
********** Error **********

ERROR: syntax error at or near "IF"
SQL state: 42601
Character: 2

Thanks

denis woodbury
denis(at)woodmic(dot)net
450-242-0249

Responses

  • Re: EXISTS at 2008-10-11 12:32:28 from Leif B. Kristensen
  • Re: EXISTS at 2008-10-11 17:32:01 from Tom Lane
  • Re: EXISTS at 2008-10-14 07:48:33 from Craig Ringer

Browse pgsql-sql by date

  From Date Subject
Next Message Leif B. Kristensen 2008-10-11 12:32:28 Re: EXISTS
Previous Message Adrian Klaver 2008-10-10 22:10:27 Re: Problem with delete trigger: how to allow only triggers to delete a row?