Postgres Pro
Downloads
Home   >   mailing lists

Re: Query causesExecSubPlan: NULL value error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Query causesExecSubPlan: NULL value error
Date
Msg-id 1669.960831288@sss.pgh.pa.us
Whole thread Raw
In response to Query causesExecSubPlan: NULL value error  ("Rick Smith" <rsmith@artschool.com>)
Responses Re: Query causesExecSubPlan: NULL value error
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: "Rick Smith"
Date:
Subject: Query causesExecSubPlan: NULL value error
Next
From: Bruce Momjian
Date:
Subject: Re: Query causesExecSubPlan: NULL value error