Re: Query causesExecSubPlan: NULL value error

"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