Re: SPAM-LOW: Re: If Statement

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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of A. Kretschmer
Sent: Sunday, February 04, 2007 8:25 PM
To: pgsql-novice(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly