pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to update a column
2+ messages / 2 participants
[nested] [flat]
* how to update a column
@ 2003-12-12 07:16 dbuechel@tiscali.ch
0 siblings, 1 reply; 2+ messages in thread
From: dbuechel@tiscali.ch @ 2003-12-12 07:16 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how to update a column
@ 2003-12-12 09:59 D'Arcy J.M. Cain <darcy@druid.net>
parent: dbuechel@tiscali.ch
0 siblings, 0 replies; 2+ messages in thread
From: D'Arcy J.M. Cain @ 2003-12-12 09:59 UTC (permalink / raw)
To: dbuechel@tiscali.ch; pgsql-interfaces
On December 12, 2003 02:16 am, dbuechel@tiscali.ch wrote:
> 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?
That's a pretty basic operation. Perhaps you can post some code that you are
having trouble with and we can help you debug it.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-12-12 09:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-12 07:16 how to update a column dbuechel@tiscali.ch
2003-12-12 09:59 ` D'Arcy J.M. Cain <darcy@druid.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox