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
I get the error ERROR: syntax error at or near "IF" at character 1
I am using EMS's PostGreSQL Manager for windows.
In response to
pgsql-novice by date
|Next:||From: A. Kretschmer||Date: 2007-02-04 18:25:28|
|Subject: Re: If Statement|
|Previous:||From: Tom Lane||Date: 2007-02-04 17:56:13|
|Subject: Re: Accessing RECORD variable info |