Re: How best to create and use associative array type in Postgres?

On 1/5/22 12:26, Shaozhong SHI wrote:
> Have a look at this one.
> 
> GitHub - theory/kv-pair: A key/value pair data type for PostgreSQL 
> <https://github.com/theory/kv-pair>
> 
> There is no documentation on how to use it.

Why use it when you have:

https://www.postgresql.org/docs/current/datatype-json.html

Or if you want something simpler:

https://www.postgresql.org/docs/current/hstore.html

> 
> Regards,
> 
> David
> 
> On Wed, 5 Jan 2022 at 16:24, Tom Lane <tgl@sss.pgh.pa.us 
> <mailto:tgl@sss.pgh.pa.us>> wrote:
> 
>     Shaozhong SHI <shishaozhong@gmail.com
>     <mailto:shishaozhong@gmail.com>> writes:
>      > What do you think this attempt by using create type and create a
>     function?
>      > Managing Key/Value Pairs in PostgreSQL (justatheory.com
>     <http://justatheory.com>)
>      > <https://justatheory.com/2010/08/postgres-key-value-pairs/
>     <https://justatheory.com/2010/08/postgres-key-value-pairs/>>
> 
>     The date alone should suggest to you that there might be
>     better ways to do it by now.
> 
>                              regards, tom lane
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com