diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2014-11-01 11:31:35 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2014-11-01 11:31:35 -0400 |
| commit | 3e81a33d799ed8c12847eb8ef1685563eeb10e7d (patch) | |
| tree | 7e526e8072b27777a16b32adc7e6fe8fd4fcd540 | |
| parent | 2bd9e412f92bc6a68f3e8bcb18e04955cc35001d (diff) | |
| download | postgresql-3e81a33d799ed8c12847eb8ef1685563eeb10e7d.tar.gz postgresql-3e81a33d799ed8c12847eb8ef1685563eeb10e7d.zip | |
PL/Python: Fix example
Revert "6f6b46c9c0ca3d96acbebc5499c32ee6369e1eec", which was broken.
Reported-by: Jonathan Rogers <jrogers@socialserve.com>
| -rw-r--r-- | doc/src/sgml/plpython.sgml | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/doc/src/sgml/plpython.sgml b/doc/src/sgml/plpython.sgml index e209b2a2d23..c838c7b79a5 100644 --- a/doc/src/sgml/plpython.sgml +++ b/doc/src/sgml/plpython.sgml @@ -1037,7 +1037,11 @@ rv = plpy.execute(plan, ["name"], 5) <xref linkend="plpython-sharing">). For example: <programlisting> CREATE FUNCTION usesavedplan() RETURNS trigger AS $$ - plan = SD.setdefault("plan", plpy.prepare("SELECT 1")) + if "plan" in SD: + plan = SD["plan"] + else: + plan = plpy.prepare("SELECT 1") + SD["plan"] = plan # rest of function $$ LANGUAGE plpythonu; </programlisting> |