Re: hstore improvements?

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: hstore improvements?
Дата
Msg-id 1821EEB2-1B30-43A7-9D57-3BB4DFAE08AA@kineticode.com
обсуждение исходный текст
Ответ на hstore improvements?  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: hstore improvements?
Re: hstore improvements?
Список pgsql-hackers
On Mar 13, 2009, at 11:06 AM, Andrew Gierth wrote:

> If there's any other features that people find notably missing from
> hstore, I could stick them in too; any requests?

Can you create slices? That is, create a new hstore as a subset of an  
existing hstore?

> Also, hstore has an (undocumented) limit of 65535 bytes for keys and
> values, and it does not behave very cleanly when given longer values
> (it truncates them mod 2^16, rather than erroring). That gives rise to
> two obvious questions: (1) are those lengths reasonable? they strike
> me as being rather long for keys and rather short for values; and (2)
> should exceeding the lengths throw an error?

I agree. The keys can be much shorter without any threat of loss. Can  
the value not essentially be TEXT, and thus theoretically unlimited in  
size?

Best,

David


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: hstore improvements?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: hstore improvements?