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(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>> wrote:
>
> Shaozhong SHI <shishaozhong(at)gmail(dot)com
> <mailto:shishaozhong(at)gmail(dot)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(dot)klaver(at)aklaver(dot)com