Re: ERROR: variable not found in subplan target lists - Mailing list pgsql-general

"Joshua D. Drake" <jd@commandprompt.com> writes:
> Tom Lane wrote:
>> such a hokey query (how many applications really write "WHERE false"?),

> Granted this isn't WHERE FALSE, but I certainly see WHERE TRUE all the
> time in similar scenarios and I have seen WHERE FALSE.

In what context?   Either "WHERE TRUE AND ..." or "WHERE FALSE OR ..."
strike me as perfectly sensible, but "WHERE FALSE AND ..." doesn't
seem to have obvious usefulness.

            regards, tom lane