Re: Inconsistent Errors on Row Comparisons

On Jun 30, 2009, at 11:27 AM, David E. Wheeler wrote:

>    # Failed test 148
>    #     Number of columns differs between queries
>    #         have: 4 columns
>    #         want: 3 columns
>
>    # Failed test 149
>    #     Column types differ between queries
>    #         have: (integer,text)
>    #         want: (inet,text)
>
> This gives the tester a lot of information to help diagnose the test  
> failure. I don't know that I can gather that kind of information,  
> though.

Actually, I can for `set_eq()`, since it creates a temporary table, I  
can just get the list of types from the system catalog. Is there a way  
to get a RECORD object to tell me what data types it contains? Then I  
could use the same error for both situations, since the difference in  
the number of columns is implicit in the list of data types:
   # Failed test 148   #     Column types differ between queries   #         have: (integer,text,integer)   #
want:(inet,text)
 
   # Failed test 149   #     Column types differ between queries   #         have: (integer,text)   #         want:
(inet,text)

Thanks,

David