sri harsha <sriharsha9...@gmail.com> writes: > Assume the following query , > (SELECT a * 1 , b FROM TABLE_1) UNION ALL (SELECT a *1 , b FROM TABLE_2);
> In this query , attribute number of the VARs are 141 and 2 respectively !! I doubt it. Maybe you're looking at something that's not a Var, possibly an OpExpr, but assuming it's a Var? The fact that 141 is the pg_proc OID of int4mul lends considerable weight to this suspicion ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers