Gregory Stark wrote:
> "Peter Eisentraut" <peter_e(at)gmx(dot)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/