Re: remaining sql/json patches
От
jian he
Тема
Re: remaining sql/json patches
Дата
Msg-id
CACJufxG2KT2ALucqfPGTn3ve47M9UE3=8UtneZ-_K9ARr-s6nw@mail.gmail.com
Ответ на
Re: remaining sql/json patches (Amit Langote)
Список
Дерево обсуждения
remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
RE: remaining sql/json patches "Shinoda, Noriyoshi (HPE Services Japan - FSIP)" <noriyoshi.shinoda@hpe.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches John Naylor <johncnaylorls@gmail.com>
Re: remaining sql/json patches John Naylor <johncnaylorls@gmail.com>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Tom Lane <tgl@sss.pgh.pa.us>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Shruthi Gowda <gowdashru@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Shruthi Gowda <gowdashru@gmail.com>
Re: remaining sql/json patches Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Andy Fan <zhihuifan1213@163.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Andy Fan <zhihuifan1213@163.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>
Re: remaining sql/json patches Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: remaining sql/json patches Himanshu Upadhyaya <upadhyaya.himanshu@gmail.com>
Re: remaining sql/json patches Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alexander Lakhin <exclusion@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alexander Lakhin <exclusion@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Michael Paquier <michael@paquier.xyz>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Thom Brown <thom@linux.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Alexander Lakhin <exclusion@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alexander Lakhin <exclusion@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Peter Smith <smithpb2250@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Robert Haas <robertmhaas@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Robert Haas <robertmhaas@gmail.com>
Re: remaining sql/json patches Andrew Dunstan <andrew@dunslane.net>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Peter Eisentraut <peter@eisentraut.org>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Peter Eisentraut <peter@eisentraut.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Andres Freund <andres@anarazel.de>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Nikita Malakhov <hukutoc@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Nikita Malakhov <hukutoc@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Nikita Malakhov <hukutoc@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Nikita Malakhov <hukutoc@gmail.com>
Re: remaining sql/json patches Nikita Malakhov <hukutoc@gmail.com>
Re: remaining sql/json patches Nikita Malakhov <hukutoc@gmail.com>
Re: remaining sql/json patches Nikita Malakhov <hukutoc@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches "Anton A. Melnikov" <a.melnikov@postgrespro.ru>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches "Anton A. Melnikov" <a.melnikov@postgrespro.ru>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Nikita Malakhov <hukutoc@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Erik Rijkers <er@xs4all.nl>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Peter Eisentraut <peter@eisentraut.org>
Re: remaining sql/json patches Tom Lane <tgl@sss.pgh.pa.us>
Re: remaining sql/json patches jian he <jian.universality@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Peter Eisentraut <peter@eisentraut.org>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
Re: remaining sql/json patches Amit Langote <amitlangote09@gmail.com>
hi.
since InitJsonItemCoercions cannot return NULL.
per transformJsonFuncExpr, jsexpr->item_coercions not null imply
jsexpr->result_coercion not null.
so I did the attached refactoring.
now every ExecInitJsonExprCoercion function call followed with:
scratch->opcode = EEOP_JUMP;
scratch->d.jump.jumpdone = -1; /* set below */
jumps_to_coerce_finish = lappend_int(jumps_to_coerce_finish,
state->steps_len);
ExprEvalPushStep(state, scratch);
It looks more consistent.
we can also change
+ */
+ if (jexpr->result_coercion || jexpr->item_coercions)
+ {
+
to
+ if (jexpr->result_coercion)
since jexpr->item_coercions not null imply jexpr->result_coercion not null.
В списке pgsql-hackers по дате отправления