If Statement - Mailing list pgsql-novice

From Greg Quinn
Subject If Statement
Date
Msg-id 000701c74888$7f6472b0$6501a8c0@melt
Whole thread Raw
In response to Re: Accessing RECORD variable info  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: If Statement
Re: If Statement
List pgsql-novice
For some reason I cannot get an IF statement to work in PostGreSQL, even
though I am doing it in the format the manual tells me to...
Here is my query...

IF 1 = 1 THEN
    update contacts set deleted = TRUE
END IF;

I get the error ERROR:  syntax error at or near "IF" at character 1

I am using EMS's PostGreSQL Manager for windows.

Thanks


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Accessing RECORD variable info
Next
From: "A. Kretschmer"
Date:
Subject: Re: If Statement