X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 7A90CD1B4B4
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Fri, 12 Dec 2003 07:17:15 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 81959-04
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Fri, 12 Dec 2003 03:16:45 -0400 (AST)
Received: from mx1.tiscali.ch (mx1.tiscali.ch [212.40.5.185])
	by svr1.postgresql.org (Postfix) with ESMTP id 8A7C1D1DE6A
	for <pgsql-interfaces@postgresql.org>;
	Fri, 12 Dec 2003 03:16:43 -0400 (AST)
Received: from [128.178.82.3] by mx1.tiscali.ch with HTTP;
	Fri, 12 Dec 2003 08:16:39 +0100
Date: Fri, 12 Dec 2003 08:16:39 +0100
Message-ID: <3FC6F87D0000A464@mx1.tiscali.ch>
From: dbuechel@tiscali.ch
Subject: how to update a column
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_30,
	NO_REAL_NAME
X-Spam-Level: 
X-Archive-Number: 200312/33
X-Sequence-Number: 4642

Hello,

I want to update only one colomn ('cout') of a PostgreSQL table (table name:
aretes; colomns: gid, long, vit, acces, cout). For each line of the table
I calculate the 'cout' attribut with Python, then I want to update the
'cout'attribut of each line with the new value. I tried with the update
function
of the pg module, but it wasn't sucessfull.

Can anyone give me some help or an example of an update command?

Thanks
Daniela