diff options
-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> |