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@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