From: | "Greg Quinn" <greg(at)officium(dot)co(dot)za> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: SPAM-LOW: Re: If Statement |
Date: | 2007-02-04 18:51:54 |
Message-ID: | 001101c7488d$931e3ed0$6501a8c0@melt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-02-04 19:06:19 | Re: SPAM-LOW: Re: If Statement |
Previous Message | A. Kretschmer | 2007-02-04 18:25:28 | Re: If Statement |