Gregory Stark wrote: > "Peter Eisentraut" <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings