Re: Better error message for select_common_type()

Gregory Stark wrote:
> "Peter Eisentraut" <peter_e@gmx.net> writes:
> > peter=# values(0,1), (1::bigint,2), ('text'::text,3);
> > ERROR:  42804: VALUES types bigint at position 2 and text at
> > position 3 cannot be matched in instance 1
> >
> > I'm not sure about the terminology "position" and "instance";
> > they're just two coordinates to get at the problem.
>
> Wouldn't that just be column 1 in rows 2 and 3?

In this case yes, but the routine is also used for UNION, IN, GREATEST, 
JOIN/USING and others.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/