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.steh...@gmail.com> wrote: > 2011/3/5 Andre Lopes <lopes80an...@gmail.com>: >> 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.steh...@gmail.com> >> 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 <lopes80an...@gmail.com>: >>>> 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@postgresql.org) >>>> To make changes to your subscription: >>>> http://www.postgresql.org/mailpref/pgsql-general >>>> >>> >> > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
