Re: PHP array to PlPgSQL arrat. How to?

[Andre Lopes <lopes80andre@xxxxxxxxx>]

Thanks again,

I saw this tutorial on how to get Key => Value,
http://justatheory.com/computers/databases/postgresql/key-value-pairs.html

It is not possible to use hstore to me.


Best Regards,



On Sat, Mar 5, 2011 at 7:42 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
> 2011/3/5 Andre Lopes <lopes80andre@xxxxxxxxx>:
>> Hi Pavel,
>>
>> Thanks for the reply.
>>
>> In PlpgSQL there is possible to define arrays with "Key => Value, Key => Value"?
>>
>
> No, no directly
>
> there are no hash array
>
> there is a workaround a hstore module
>
> http://www.postgresql.org/docs/9.0/static/hstore.html
>
> attention - it doesn't allow a nested values
>
> Regards
>
> Pavel Stehule
>
> for more complex values is other was - using a temp tables - you can
> fill a temp table and in next step a plpgsql code use this temp table.
> But it should have a performance impacts.
>
>
>
>> Best Regards,
>>
>>
>> On Sat, Mar 5, 2011 at 7:28 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
>>> Hello
>>>
>>> there isn't a simple way :(
>>>
>>> the most simply way is using string_to_array function
>>>
>>> SELECT func(string_to_array('1,2,3,4,5',','));
>>>
>>> Regards
>>>
>>> Pavel Stehule
>>>
>>>
>>> 2011/3/5 Andre Lopes <lopes80andre@xxxxxxxxx>:
>>>> Hi,
>>>>
>>>> I need to transform an PHP array to an PlPgSQL array. The PHP array is
>>>> like this:
>>>>
>>>> [quote]
>>>> $arr = array(
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â0 => array(
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"base64" => "ddfffffff",
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"image_type" => "jpg",
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"width" => "343",
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"height" => "515",
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"html_width_height" => 'width="343" height="515"',
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"mime" => "image/jpeg"
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â),
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â1 => array(
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"base64" => "ddfffffffddddd",
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"image_type" => "jpg",
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"width" => "343",
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"height" => "515",
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"html_width_height" => 'width="343" height="515"',
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â"mime" => "image/jpeg"
>>>> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â)
>>>> Â Â Â Â Â Â Â Â Â Â Â Â);
>>>> [/quote]
>>>>
>>>> How can I pass this kinf of PHP array to PlPgSQL?
>>>>
>>>> Give me a clue.
>>>>
>>>> Best Regards,
>>>>
>>>> --
>>>> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/mailpref/pgsql-general
>>>>
>>>
>>
>

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general