Question about Array data type in PostgreSQL and their link with hash table concept

Поиск
Список
Период
Сортировка
От Dariyoosh Dariyoosh
Тема Question about Array data type in PostgreSQL and their link with hash table concept
Дата
Msg-id CA+fe79qN25+5qXRXZw6B8-TiS9ybbhoGPOr653UQtR87M946VA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question about Array data type in PostgreSQL and their link with hash table concept  (Luca Vernini <lucazeo@gmail.com>)
Список pgsql-sql
Hi,

I would like to ask a question about Array type. My question is somewhat a comparison between
Oracle PL/SQL & PostgreSQL.

I was reading the online documentation at the following link about the Array data type and
I read the following note:

http://www.postgresql.org/docs/9.3/interactive/arrays.html
Tip: Arrays are not sets; searching for specific array elements can be a sign of database misdesign.
Consider using a separate table with a row for each item that would be an array element.
This will be easier to search, and is likely to scale better for a large number of elements.

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?

Thanks in advance,

В списке pgsql-sql по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: How to clean up phone-numbers with regex?
Следующее
От: Luca Vernini
Дата:
Сообщение: Re: Question about Array data type in PostgreSQL and their link with hash table concept