en
Timo Klecker
Von: Rajan, Pavithra [mailto:raj...@coned.com]
Gesendet: Freitag, 26. März 2010 15:17
An: Timo Klecker; pgsql-general@postgresql.org
Betreff: RE: [GENERAL] Need help on updating an entire column with a list of
values, I have.
Hello ,
Yes -I nee
mo Klecker; pgsql-general@postgresql.org
Betreff: RE: [GENERAL] Need help on updating an entire column with a list of
values, I have.
Hello ,
Yes -I need to get the exact the same result as you had listed.Thanks.
From: Timo Klecker [mailto:klec...@decoit
n code was not tested!
Mit freundlichen Grüßen
Timo Klecker
Von: Rajan, Pavithra [mailto:raj...@coned.com]
Gesendet: Freitag, 26. März 2010 15:17
An: Timo Klecker; pgsql-general@postgresql.org
Betreff: RE: [GENERAL] Need help on updating an entire column with a list of
valu
you can't really do any updates sensibly unless you know what the relation
is. So, I kind of silently assume that you know that.
W dniu 26 marca 2010 15:21 użytkownik Grzegorz Jaśkiewicz napisał:
> create temporary table, insert your data, and than run update with join
> against the table you wish to modify. And than drop your temp table.
> simple.
>
>
It would be a nice solution, assuming that we know anything about the
c
get tricky.
Mit freundlichen Grüßen
Timo Klecker
Von: Rajan, Pavithra [mailto:raj...@coned.com]
Gesendet: Freitag, 26. März 2010 15:17
An: Timo Klecker; pgsql-general@postgresql.org
Betreff: RE: [GENERAL] Need help on updating an entire column with a list of
values, I have.
Hello
create temporary table, insert your data, and than run update with join
against the table you wish to modify. And than drop your temp table.
simple.
On 26 March 2010 13:47, Rajan, Pavithra wrote:
> Hello - I have this table with 90 rows, which contains 2 columns ,column A
> (type 'numeric') and column B(type text) . Column 'A' is filled with a
> constant number and column 'B' has an unique entry for each row.
>
> E.g. A
Hello,
what do you expect as Result? Something like this?
E.g. A B
(numeric)(text)
06959.0 002
15308.0 003
15968.0 004
18916.0 011
19961.0
Hello ,
Yes -I need to get the exact the same result as you had listed.Thanks.
From: Timo Klecker [mailto:klec...@decoit.de]
Sent: Friday, March 26, 2010 10:12 AM
To: Rajan, Pavithra ; pgsql-general@postgresql.org
Subject: AW: [GENERAL] Need help on updati
2010/3/26 Rajan, Pavithra
> Hello - I have this table with 90 rows, which contains 2 columns ,column
> A (type 'numeric') and column B(type text) . Column 'A' is filled with a
> constant number and* column 'B' has an unique entry for each row*.
>
> E.g. A B
>
11 matches
Mail list logo
