Re: ERROR: variable not found in subplan target lists

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Miroslav S(ulc <miroslav(dot)sulc(at)startnet(dot)cz>, PGSQL mailing list <pgsql-general(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Subject: Re: ERROR: variable not found in subplan target lists
Date: 2007-10-04 17:33:09
Message-ID: 24922.1191519189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Joshua D. Drake" <jd(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken.Colson 2007-10-04 17:39:05 Re: good sql tutorial
Previous Message Joshua D. Drake 2007-10-04 17:26:50 Re: ERROR: variable not found in subplan target lists