Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi,# SELECT '[[5,2],"a",[8,[3,2],6]]'::jsonb; jsonb------------------------------- [[5, 2], "a", [8, [3, 2], 6]](1 row)unnest(array[[3,2],"a",[1,4]]) is not accepted currently.Would the enhanced unnest accept the above array ?
CheersOn Sun, Feb 7, 2021 at 8:31 AM Joel Jacobson <joel@compiler.org> wrote:On Sun, Feb 7, 2021, at 17:27, Tom Lane wrote:>"Joel Jacobson" <joel@compiler.org> writes:>> Having thought about this some more,>> the function name should of course be jsonb_unnest(),>> similar to how unnest() works for normal arrays:>>Why not just unnest(), then?>>regards, tom laneAhh, of course! I totally forgot about function overloading when thinking about this.+1/Joel
On Sun, Feb 7, 2021, at 17:27, Tom Lane wrote:>"Joel Jacobson" <joel@compiler.org> writes:>> Having thought about this some more,>> the function name should of course be jsonb_unnest(),>> similar to how unnest() works for normal arrays:>>Why not just unnest(), then?>>regards, tom laneAhh, of course! I totally forgot about function overloading when thinking about this.+1/Joel
В списке pgsql-hackers по дате отправления: