From 3c6ff6adaec23d34f0a91a3889801589b10082e2 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 7 Aug 2014 10:43:55 -0400 Subject: -Fixed bug where Postgresql JSON type was not able to persist or otherwise render a SQL NULL column value, rather than a JSON-encoded ``'null'``. To support this case, changes are as follows: * The value :func:`.null` can now be specified, which will always result in a NULL value resulting in the statement. * A new parameter :paramref:`.JSON.none_as_null` is added, which when True indicates that the Python ``None`` value should be peristed as SQL NULL, rather than JSON-encoded ``'null'``. Retrival of NULL as None is also repaired for DBAPIs other than psycopg2, namely pg8000. fixes #3159 --- doc/build/changelog/changelog_09.rst | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'doc') diff --git a/doc/build/changelog/changelog_09.rst b/doc/build/changelog/changelog_09.rst index cde13441f..a797bfa29 100644 --- a/doc/build/changelog/changelog_09.rst +++ b/doc/build/changelog/changelog_09.rst @@ -13,6 +13,25 @@ .. changelog:: :version: 0.9.8 + .. change:: + :tags: bug, postgresql + :versions: 1.0.0 + :tickets: 3159 + + Fixed bug where Postgresql JSON type was not able to persist or + otherwise render a SQL NULL column value, rather than a JSON-encoded + ``'null'``. To support this case, changes are as follows: + + * The value :func:`.null` can now be specified, which will always + result in a NULL value resulting in the statement. + + * A new parameter :paramref:`.JSON.none_as_null` is added, which + when True indicates that the Python ``None`` value should be + peristed as SQL NULL, rather than JSON-encoded ``'null'``. + + Retrival of NULL as None is also repaired for DBAPIs other than + psycopg2, namely pg8000. + .. change:: :tags: bug, sql :versions: 1.0.0 -- cgit v1.2.1