Re: Update with function

On Fri, 2012-03-30 at 06:45 -0700, Adrian Klaver wrote:

> A simple solution that demonstrates one way to do the above:
>
>
> cur.execute("select recno from some_table")
>
> for row in cur:
>     recno = cur[0]
>     cur.execute("update books set inyear=%s", (makeyear(recno),))
>
Thanks for your suggestion, Adrian.
Actually, that was something I tried first.
But my some_table is about 165000 records, and it took nearly three
hours (on my not so young system) to run the individual updates.
So I looked for a one-pass solution.
egbert

--
Egbert Bouwman
Keizersgracht 197-II
1016 DS  Amsterdam
Tel 0(031)20 6257991