Hi,

plan = plpy.prepare("SELECT last_name FROM my_users WHERE first_name =
$1", [ "text" ])
rv = plpy.execute(plan, [ "name" ], 5)
return rv["last_name"]

If the SELECT command does not return any results, how do I
catch/check for this?

if rv == {} ?

or maybe

try:
  rv = plpy.execute(plan, [ "name" ], 5)
  return rv["last_name"]
except:
  ...
else:
  ...

can't seem to get either to work.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to