Re: Inconsistent Errors on Row Comparisons

On Jun 30, 2009, at 3:05 PM, David Fetter wrote:

>>> Would this be the first C piece? If not, it might be worth doing.
>>
>> I don't understand the question.
>
> I was thinking of this as part of PgTAP.

Oh. There is a piece of C, but it's just an implementation of
pg_typeof() so that pgTAP can use it in versions of PostgreSQL < 8.4.
In 8.4 and later, no C code is built. Have been trying to keep it that
way for now.

>> But yes, I think it'd be worth doing. I'd like to have functions
>> like:
>>
>> pg_record_attrs(RECORD) RETURNS SETOF regtype[]
>>
>> And maybe another function to return attribute names. If it could
>> returns both names and types, that'd be cool, but I'm not sure what
>> kind
>> of data type that would be.
>
> It's possible to have it return SETOF RECORD with OUT parameters, I
> think.

Out parameters? I was thinking of SETOF RECORD with two attributes in
each record: name and type. Are there other attributes of RECORD
attributes that might be of interest?

>> Does this sound interesting to other folks?
>
> Sure. Maybe that should go in pg_catalog in 8.5...

Right, that was my thought. I could then throw it in pgTAP when
building on < 8.5.

Best,

David