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@sss.pgh.pa.us> wrote:
>> 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