| From: | Dariyoosh Dariyoosh <d(dot)sunforums(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Question about Array data type in PostgreSQL and their link with hash table concept |
| Date: | 2014-05-27 12:39:59 |
| Message-ID: | CA+fe79qN25+5qXRXZw6B8-TiS9ybbhoGPOr653UQtR87M946VA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Vernini | 2014-05-27 12:44:39 | Re: Question about Array data type in PostgreSQL and their link with hash table concept |
| Previous Message | David G Johnston | 2014-05-19 15:52:12 | Re: How to clean up phone-numbers with regex? |