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 <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (Adrian Klaver) writes: > > From: "Alain Roger" <[EMAIL PROTECTED]> > >> 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
