Skip site navigation (1) Skip section navigation (2)

Re: Update with function

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: egbert(dot)bouwman(at)xs4all(dot)nl
Cc: psycopg(at)postgresql(dot)org
Subject: Re: Update with function
Date: 2012-03-30 16:05:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: psycopg
On 03/30/2012 09:02 AM, egbert wrote:
> 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.

Another option is write function in Postgres that does what you want and 
call that function.

> egbert

Adrian Klaver

In response to


psycopg by date

Next:From: Daniele VarrazzoDate: 2012-03-30 16:07:50
Subject: Re: Update with function
Previous:From: egbertDate: 2012-03-30 16:02:40
Subject: Re: Update with function

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group