Re: UNION ALL - Var attno

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sri harsha <sriharsha9992(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UNION ALL - Var attno
Date: 2016-04-29 04:33:32
Message-ID: 26053.1461904412@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

sri harsha <sriharsha9992(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-04-29 04:39:32 Re: VS 2015 support in src/tools/msvc
Previous Message Andrew Dunstan 2016-04-29 04:15:01 Re: VS 2015 support in src/tools/msvc