Re: pl/pgsql and controling loops

["Alain Roger" <raf.news@xxxxxxxxx>]

this is what i did, and it's true that '==' does not exist under pl/pgsql. Only '=' should be used.

On Thu, Mar 27, 2008 at 8:53 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

aklaver@xxxxxxxxxxx (Adrian Klaver) writes:
> From: "Alain Roger" <raf.news@xxxxxxxxx>

>> once to do a comparison they use :
> IF (ret == 1) THEN ...
>> once,
> IF (ret = 1) THEN...

> Both are correct.

No they're not, as a simple test would convince you ...
there is no '==' operator in SQL.

                       regards, tom lane

-- 
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008