Roger Niederland <roger@xxxxxxxxxxxxxx> writes: > I stripped down the original query to what is below. I am not saying > that the query below > is useful except to show an error I am getting in Postgresql 9.1.1 on > both SL6.1 (64 bit) and > Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I am getting is: > ERROR: variable not found in subplan target list This is a pretty typical symptom of a certain class of planner bugs, but I couldn't reproduce any such failure on the basis of what you showed here. Please provide a *self-contained* test case. http://wiki.postgresql.org/wiki/Guide_to_reporting_problems regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general