Horton

Re: Query causesExecSubPlan: NULL value error

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Rick Smith" <rsmith@artschool.com>
Cc: pgsql-bugs@postgresql.org
Date: 2000-06-12T17:34:48Z
Lists: pgsql-bugs 
"Rick Smith" <rsmith@artschool.com> writes:
>    PostgreSQL version (example: PostgreSQL-6.5.3) :PostgreSQL-6.5.3
                                                     ^^^^^^^^^^^^^^^^
>  	ERROR:  ExecSubPlan: null value returned by expression subselect

6.5 and older don't cope with sub-selects returning NULL.  This is fixed
in Postgres 7.0.

			regards, tom lane