Associative arrays in PostgreSQL

Question

PostgreSQL

Good day.

I'm interested in the question of the presence of associative arrays in Postgre as well as the search for it. Ordinary index arrays exist, and searching for them is clear to me, but I can not find any information on associative arrays.

Ideally would like to see that thread type: Thank you

select * from TABLE where tags['name']='value';


Answer 1

www.postgresql.org/docs/9.0/static/hstore.html

Answer 2

there is no such thing, use tables, that's what they are for

Answer 3

Yes, you, my friend, are an optimist ... If this were the case, then there would be no need to invent non-relational databases.

Answer 4

Alternatively, use temporary tables.
PostgreSQL supports them, there shouldn't be any problems.
postgrestips.blogspot.com/2007/07/temp.html