Re: Create and access a dictionary type

Поиск
Список
Период
Сортировка
Искать
От
Tomas Vondra
Тема
Re: Create and access a dictionary type
Дата
Msg-id
39f8bf99-0cba-912f-8edf-40776954f631@enterprisedb.com
Ответ на
Список
Дерево обсуждения
Create and access a dictionary type Shaozhong SHI <shishaozhong@gmail.com>
Re: Create and access a dictionary type Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Create and access a dictionary type Shaozhong SHI <shishaozhong@gmail.com>
Re: Create and access a dictionary type Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Create and access a dictionary type Ron <ronljohnsonjr@gmail.com>
Re: Create and access a dictionary type Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Create and access a dictionary type Ron <ronljohnsonjr@gmail.com>
Re: Create and access a dictionary type Rob Sargent <robjsargent@gmail.com>
On 1/5/22 14:36, Shaozhong SHI wrote:
> I just checked operators.  I could not find any operator to set a new 
> value given a key.
> 

I'd say jsonb_set is what you're looking for.

Postgres does not have a thing that'd match the Oracle feature exactly, 
you'll have to adjust your application to use what's available.

regards


-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-general по дате отправления
От: Tomas Vondra
Дата:
От: Ron
Дата:
FAQ