Postgres Pro
Downloads
Home   >   mailing lists

Re: Handling NULL records in plpgsql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Handling NULL records in plpgsql
Date
Msg-id 23058.1224911914@sss.pgh.pa.us
Whole thread Raw
In response to Re: Handling NULL records in plpgsql  (Decibel! <decibel@decibel.org>)
List pgsql-hackers
Tree view 
Decibel! <decibel@decibel.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

pgsql-hackers by date:

Previous
From: Decibel!
Date:
Subject: Re: Handling NULL records in plpgsql
Next
From: Decibel!
Date:
Subject: Re: Regression in IN( field, field, field ) performance