Re: Proposal: casts row to array and array to row

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal: casts row to array and array to row
Date: 2011-10-11 12:48:11
Message-ID: CAFj8pRDediJUfX7iCqGSGwNp12Hk=w0HnpkSW0bquQMeHWrupA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Boszormenyi Zoltan 2011-10-11 12:51:13 Re: Proposal: casts row to array and array to row
Previous Message Pavel Stehule 2011-10-11 12:45:14 Re: Proposal: casts row to array and array to row