Re: Using JSONB with nested key-value structures, andskipping/wildcarding the key

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Using JSONB with nested key-value structures, andskipping/wildcarding the key
Дата
Msg-id 0d9a4455-3146-7aee-f4ee-732927f55a47@gmx.net
обсуждение исходный текст
Ответ на Re: Using JSONB with nested key-value structures, andskipping/wildcarding the key  (Shaheed Haque <shaheedhaque@gmail.com>)
Список pgsql-general
> One question: as a novice here, I think I understand the right hand
> side of your JOIN "... k(value)" is shorthand for:
>
> ... AS table_name(column_name)
>
> except that I don't see any clues in the docs that
> jsonb_object_keys() is a "table function".> Can you kindly clarify?

The clue is in the column "return type" which states: "setof text" for jsonb_object_keys()
A function returning "setof" is the same as a "table function"




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

Предыдущее
От: Shaheed Haque
Дата:
Сообщение: Re: Using JSONB with nested key-value structures, andskipping/wildcarding the key
Следующее
От: Ron
Дата:
Сообщение: Re: Oracle vs. PostgreSQL - a comment