Search Postgresql Archives

Re: How to deal with field on the database that stores variable array's?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2011/1/1 Andre Lopes <lopes80andre@xxxxxxxxx>
Hi,

I need to develop a database table that will aceept a variable array field. My doubt is how to deal with updates on the
array field. How can I store the information of the array fields? There any examples on the Internet on how to deal with
this subject?

What I mean with variable array is:


array(
ÂÂÂÂÂ 'name' => 'Don',
ÂÂÂÂÂ 'age'Â => '31'
ÂÂÂÂ );


array(
ÂÂÂÂÂ 'name' => 'Peter',
ÂÂÂÂÂ 'age'Â => '28',
ÂÂÂÂÂ 'car'Â => 'ford',
ÂÂÂÂÂ 'km'ÂÂ => '2000'
ÂÂÂÂ );


Best Regards,
I recommend to use hstore. It is well designed, mature and proven.
I believe that hstore became built-in type in PostgreSQL.



--
// Dmitriy.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux