Postgres Pro
Downloads
Home   >   mailing lists

Re: pl/pgsql and controling loops - Mailing list pgsql-general

From Alain Roger
Subject Re: pl/pgsql and controling loops
Date
Msg-id 75645bbb0803271301p57a26423ia196b4dcd71c6246@mail.gmail.com
Whole thread Raw
In response to Re: pl/pgsql and controling loops  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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:
aklaver@comcast.net (Adrian Klaver) writes:
> From: "Alain Roger" <raf.news@gmail.com>
>> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pl/pgsql and controling loops
Next
From: Zdenek Kotala
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)