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