From: | "Alain Roger" <raf(dot)news(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pl/pgsql and controling loops |
Date: | 2008-03-27 19:03:32 |
Message-ID: | 75645bbb0803271203y53ea48c7o8f54ed748f88929e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
i've read several books extract about controlling loops in postgreSQL under
pl/pgsql and there is something interesting.
once to do a comparison they use :
> IF (ret == 1) THEN ...
once,
> IF (ret = 1) THEN...
so are they both correct ?
comming from .NET/C++ world, usually we use '==' or '!=', so i expect that
correct ones are '==' and '<>'.
moreover, when i check if the returned value "ret_email" from SELECT email
INTO ret_email FROM tmp_newsletterreg WHERE tmp_usr_id = id_session;
i want to check if it is empty or not, so i do IF(ret_email <> '' ) THEN...
but it does not work... every time it enter in the loop, even if it is empty
string.
where is the problem ?
thx.
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2008-03-27 19:13:44 | Re: pl/pgsql and controling loops |
Previous Message | Dawid Kuroczko | 2008-03-27 18:03:16 | Re: Survey: renaming/removing script binaries (createdb, createuser...) |