| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: proposal: plpgsql - iteration over fields of rec or row variable |
| Date: | 2010-11-09 18:00:02 |
| Message-ID: | AANLkTimp1=QD+zHyYFeQbqV==_YZ2fuSbw8NB5Yh44ky@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>>
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-11-09 18:07:17 | Re: pg_ctl init doc bug |
| Previous Message | Pavel Stehule | 2010-11-09 17:50:32 | Re: proposal: plpgsql - iteration over fields of rec or row variable |