Re: PL/Python prepare example's use of setdefault - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: PL/Python prepare example's use of setdefault
Date
Msg-id 545506B1.6070608@gmx.net
Whole thread Raw
In response to Re: PL/Python prepare example's use of setdefault  (Jonathan Rogers <jrogers@socialserve.com>)
Responses Re: PL/Python prepare example's use of setdefault
List pgsql-general
On 10/15/14 5:58 PM, Jonathan Rogers wrote:
> BTW, I would rewrite the 9.1 example to be shorter while
> behaving the same:
>
>
> CREATE FUNCTION usesavedplan() RETURNS trigger AS $$
>     plan = SD.get("plan")
>     if plan is None:

If we're going for shortness, how about

    if not plan:

?

>         SD["plan"] = plan = plpy.prepare("SELECT 1")

and here maybe

    plan = SD["plan"] = plpy.prepare("SELECT 1")

to emphasize the assignment to "plan"?

>     # rest of function
> $$ LANGUAGE plpythonu;



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: PL/Python prepare example's use of setdefault
Next
From: "Andrus"
Date:
Subject: Re: Converting char to varchar automatically