Re: Better error message for select_common_type() - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Better error message for select_common_type()
Date
Msg-id 87lkgi3ifb.fsf@oxford.xeocode.com
Whole thread Raw
In response to Better error message for select_common_type()  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Better error message for select_common_type()  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
"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?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Better error message for select_common_type()
Next
From: Neil Conway
Date:
Subject: RETURN QUERY in PL/PgSQL?