Re: proposal: plpgsql - iteration over fields of rec or row variable - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal: plpgsql - iteration over fields of rec or row variable
Date
Msg-id AANLkTimp1=QD+zHyYFeQbqV==_YZ2fuSbw8NB5Yh44ky@mail.gmail.com
Whole thread Raw
In response to Re: proposal: plpgsql - iteration over fields of rec or row variable  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
>>
>> What are you going to do with the type once you have it?
>>
>
> for example, you can use it for formatting, for explicit cast, for
> different serialization type - like JSON - without knowledge of type,
> you can't to build correct JSON value. So you can write a application
> with knowledge of type and you don't need to detect type from value,
> that isn't robust.
>

there is other disadvantage of access to fields via PL function (or
native function) based on transformation to text. It's a lost of
typmod.

Pavel

> Pavel
>
>> David
>>
>>
>


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: plpgsql - iteration over fields of rec or row variable
Next
From: Tom Lane
Date:
Subject: Re: pg_ctl init doc bug