___
From: Timo Klecker [mailto:klec...@decoit.de]
Sent: Friday, March 26, 2010 10:51 AM
To: Rajan, Pavithra ; pgsql-general@postgresql.org
Subject: AW: [GENERAL] Need help on updating an entire column with a list of
values, I have.
Hello,
you could use an plpgsql function:
CREATE OR REPLA
neral@postgresql.org
Subject: AW: [GENERAL] Need help on updating an entire column with a list of
values, I have.
Hello,
you could use an plpgsql function:
CREATE OR REPLACE FUNCTION update(numeric[])
RETURNS void AS
$BODY$
declare
data alias for $1;
table_obj record;
I in
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
Gesendet: Freitag, 26. März 2010 14:48
An: pgsql-general@postgresql.org
Betreff: [GENERAL] Need help on updating an entire column with a list of
values, I have.
Hello - I have this table with 90 rows, which contains 2 columns ,column A
(type 'numeric') and column B(type text) . Column &#x
...@postgresql.org] Im Auftrag von Rajan, Pavithra
Gesendet: Freitag, 26. März 2010 14:48
An: pgsql-general@postgresql.org
Betreff: [GENERAL] Need help on updating an entire column with a list of
values, I have.
Hello - I have this table with 90 rows, which contains 2 columns ,column A
(type
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
>
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
(numeric)(text)
12 matches
Mail list logo
