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 AANLkTinTQVSwaV9h8_BpiSASAPD2pcAHxWgOq+TpY0r0@mail.gmail.com
Whole thread Raw
In response to Re: proposal: plpgsql - iteration over fields of rec or row variable  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
2010/11/9 David E. Wheeler <david@kineticode.com>:
> On Nov 9, 2010, at 9:35 AM, Pavel Stehule wrote:
>
>>> You realize you can pretty much do all this with hstore, right?
>>
>> hstore has similar functionality, but missing a some details and add
>> lot of other functionality - it doesn't identify type of field.
>> Personally - it is nothing what I like - but can be better than
>> nothing.
>
> The JSON data type will give you some basic types (text, number, boolean).
>

yes, but it's same - transformation via text, and still it's more than
less hack - when you like to iterate over record, then you need to
transform record (generic and basic type) to JSON and then to text.
It's nothing nice - and I don't see a difference between a use a
Plperl or JSON.

Pavel

> Best,
>
> David
>
>


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: proposal: plpgsql - iteration over fields of rec or row variable
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: plpgsql - iteration over fields of rec or row variable