Re: My honours project - databases using dynamically attached entity-properties

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: My honours project - databases using dynamically attached entity-properties
Дата
Msg-id 45FAA207.30401@dunslane.net
обсуждение исходный текст
Ответ на Re: My honours project - databases using dynamically attached entity-properties  (tomas@tuxteam.de)
Ответы Re: My honours project - databases using dynamically attached entity-properties  (tomas@tuxteam.de)
Список pgsql-hackers
tomas@tuxteam.de wrote:
>
>> Does hstore nest? My impression is that it doesn't. Which might well not 
>> matter, of course.
>>     
>
> If what you mean is to have "mappings of mappings" then no.
>
> Hstore implements a data type for a (finite) mapping (a set of key -> value
> pairs, think "hash" for perl folks), with operations like "H1 contains
> H2" (in the sense that all key-value pairs in H2 are also in H1)
> supported by an index. Keys and values are strings.
>
>   

As a perl folk I think of hashes as nestable :-). Unlike hstore, the 
keys are strings but the values can be anything, including a hashref or 
arrayref.

Anyway, this means that you can't use hstore to cover the same field as 
YAML or JSON. That doesn't mean it's not useful - far from it.

cheers

andrew


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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: tsearch_core for inclusion
Следующее
От: Tom Lane
Дата:
Сообщение: Re: UPDATE using sub selects