Ok, then how do I make sure my query uses plpsql?
I have tried
IF 1 = 1 THEN
update contacts set deleted = TRUE
END IF;
LANGUAGE 'plpgsql';
But I still get the same error.
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of A. Kretschmer
Sent: Sunday, February 04, 2007 8:25 PM
To: pgsql-novice@postgresql.org
Subject: SPAM-LOW: Re: [NOVICE] If Statement
IF is only possible inside plpgsql¹, not in plain SQL. And, your check is
always true because 1 = 1 is always true.
¹ or an other language
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
