Hello,
I am new to this list, and a fairly unsophisticated user of postgresql
and psycopg.
I try to update one field in all records of a table.
The new value is too complicated for a simple expression, so I thought
about a python function. That function uses another field, recno, from
each record.
My question is: how do I pass that second field to the function.
The relevant parts of my script are now:
define makeyear(nummer):
# ...
return value
cur.execute("update books set inyear=%s", (makeyear(recno),))
The error message says that recno is not defined.
egbert
--
Egbert Bouwman
Keizersgracht 197-II
1016 DS Amsterdam
Tel 0(031)20 6257991