Re: PHP array to PlPgSQL arrat. How to?
От | Andre Lopes |
---|---|
Тема | Re: PHP array to PlPgSQL arrat. How to? |
Дата | |
Msg-id | AANLkTik0jrhHfa-Marafng7hoSWUm--9QSgZ4EX2nSuw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: PHP array to PlPgSQL arrat. How to? (Pavel Stehule <pavel.stehule@gmail.com>) |
Список | pgsql-general |
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@gmail.com> wrote: > 2011/3/5 Andre Lopes <lopes80andre@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.stehule@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 <lopes80andre@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 >>>> >>> >> >
В списке pgsql-general по дате отправления: