Skip site navigation (1) Skip section navigation (2)

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 00:19:15
Message-ID: 7317.1224893955@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Decibel! <decibel(at)decibel(dot)org> writes:
> Was anything ever done with http://archives.postgresql.org/pgsql-hackers/2008-09/msg01758.php ?

No, we got stalled on what the behavior really ought to be:
http://archives.postgresql.org/pgsql-hackers/2008-09/msg01772.php

> I have a different issue I'm seeing, but I think it's related, and  
> ISTM it's a bug (on 8.2.10):

It's entirely possible for a row variable to be in a state where neither
IS NULL nor IS NOT NULL is true.  RTFM (under Comparison Operators) or
see the SQL spec.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-10-25 00:57:17
Subject: Re: SPI cursor functions
Previous:From: Tom LaneDate: 2008-10-25 00:07:54
Subject: Re: WIP : change tablespace for a database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group