| From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | plpgsql help - nested loops |
| Date: | 2001-01-02 23:20:57 |
| Message-ID: | Pine.LNX.4.21.0101030107140.28193-200000@nanu.visionforisrael.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
I'm trying to compare the fields of two loop record variables. The loops
are nested, the compare is done inside the inner one. If given this:
raise notice ''sloop.serialnumber=%, rloop.serialnumber=%'',
sloop.serialnumber, rloop.serialnumber;
if sloop.serialnumber=rloop.serialnumber then
raise notice '' SN match'';
else
raise notice '' SN mis-match'';
end if;
the output is
NOTICE: sloop.serialnumber=<NULL>, rloop.serialnumber=<NULL>
NOTICE: SN mis-match
However, if you change the comparison to
if sloop.serialnumber=rloop.serialnumber or
(sloop.serialnumber=null and rloop.serialnumber=null) then
raise notice '' SN match'';
else
raise notice '' SN mis-match'';
end if;
everything is fine.
Question: does null=null evaluate to true, false, or null? If in psql you
do SELECT null=null; it returns true. Am I missing something? Attached
is the full trigger code..
Thanks,
-Cedar
| Attachment | Content-Type | Size |
|---|---|---|
| matchitems | text/plain | 3.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-03 00:14:48 | Re: Asynchronous interface help? |
| Previous Message | Ingo Luetkebohle | 2001-01-02 22:53:21 | Re: DBD::Pg |