Re: Proposal: casts row to array and array to row - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Proposal: casts row to array and array to row
Date
Msg-id CAFj8pRDediJUfX7iCqGSGwNp12Hk=w0HnpkSW0bquQMeHWrupA@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: casts row to array and array to row  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
>
> sometimes he can use a numeric or int array, sometimes he have to
> select text array. Target type is selected by user, and cast fail when
> conversion is not possible.
>

using a some selected type (for array field) allows a processing in plpgsql.

motivation for this feature is simplification and speedup similar
requests like this

http://stackoverflow.com/questions/7711432/how-to-set-value-of-composite-variable-field-using-dynamic-sql/7722575#7722575

Pavel


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Proposal: casts row to array and array to row
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: Proposal: casts row to array and array to row