Re: Handling NULL records in plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Decibel! <decibel(at)decibel(dot)org>
Cc: Postgres Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Handling NULL records in plpgsql
Date: 2008-10-25 05:18:34
Message-ID: 23058.1224911914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Decibel! <decibel(at)decibel(dot)org> writes:
> ... I would argue that rowvar_b IS NOT NULL should be false and rowvar_a
> IS NOT NULL should be true.

While I don't necessarily disagree with you about what is sane, what
is required by the SQL spec seems pretty clear here.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Decibel! 2008-10-25 05:32:30 Re: Regression in IN( field, field, field ) performance
Previous Message Decibel! 2008-10-25 05:00:23 Re: Handling NULL records in plpgsql