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: | 4F75D9B0.7060104@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Daniele Varrazzo | 2012-03-30 16:07:50 | Re: Update with function |
Previous Message | egbert | 2012-03-30 16:02:40 | Re: Update with function |