Re: Inconsistent Errors on Row Comparisons

On Tue, Jun 30, 2009 at 03:16:09PM -0700, David Wheeler wrote:
> 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.

OK, so the can is already open, but you're trying to discourage the
worms from escaping. :)

>>> 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?

CREATE OR REPLACE FUNCTION pg_record_info(   IN r RECORD,   OUT "regtype" RETYPE,   OUT "name" NAME,
) RETURNS SETOF RECORD
LANGUAGE C
AS 'filename', 'pg_record_info';

> 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.

Right :)

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate