Re: Question about Array data type in PostgreSQL and their link with hash table concept
От
Dariyoosh Dariyoosh
Тема
Re: Question about Array data type in PostgreSQL and their link
with hash table concept
Дата
Msg-id
CA+fe79paQSMMVuzwB+3Zc0aFySbKLKmQRdrFmFFWHc8AgiUFDg@mail.gmail.com
Ответ на
Re: Question about Array data type in PostgreSQL and their link
with hash table concept (Luca Vernini)
Список
Дерево обсуждения
Question about Array data type in PostgreSQL and their link with hash
table concept Dariyoosh Dariyoosh <d.sunforums@gmail.com>
Re: Question about Array data type in PostgreSQL and their link
with hash table concept Luca Vernini <lucazeo@gmail.com>
Re: Question about Array data type in PostgreSQL and their link
with hash table concept Dariyoosh Dariyoosh <d.sunforums@gmail.com>
Hi,
Thanks a lot for your clarification and the link about hstoreOn Tue, May 27, 2014 at 2:44 PM, Luca Vernini <lucazeo@gmail.com> wrote:
2014-05-27 14:39 GMT+02:00 Dariyoosh Dariyoosh <d.sunforums@gmail.com>:No, arrays in PostgreSQL are just arrays.
> Are arrays in PostgreSQL like associative arrays in Oracle PL/SQL hash
> tables?, that is an
> association between key & values? where the integer indexes stand in reality
> for keys?
You can consider the position like a special case of key.. but it is
not, because it is just a position and cannot be set.
For key value you can consider hstore:
http://www.postgresql.org/docs/9.3/static/hstore.html
Or build your own multi dimension array.
> Thanks in advance,
Regards,
Lucazeo.
В списке pgsql-sql по дате отправления
От: Luca Vernini
Дата:
