vecor/list INSERT or UPDATE

From: Adam Kornick <akornick(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: vecor/list INSERT or UPDATE
Date: 2001-02-23 22:05:51
Message-ID: m3y9ux3vi8.fsf@whg-florida.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

SQL Gurus,

I want to update a specific set of rows in a column with a list or
vector. Something like,

UPDATE some_table SET col = [1 2 3 4 5]
WHERE some_condition_limits_to_five_rows;

but all I see UPDATE accepting is a scalar ("5") not a vector or list
("1 2 3 4 5")...is this even possible?

Thanks,
Adam

---
Here's a clearer (hopefully) but longer example

RPGSL_ROW_NUMBER SOME_VARIABLE

4 12
5 13
6 14
7 14
8 14


SOME_VARIABLE to be replaced with 1:5 using UPDATE so that we get

RPGSL_ROW_NUMBER SOME_VARIABLE

4 1
5 2
6 3
7 4
8 5

Adam

Responses

Browse pgsql-general by date

  From Date Subject
Next Message garth 2001-02-23 22:42:06 Re: Handling of large objects in DBD::Pg? (fwd)
Previous Message Sipos Andras 2001-02-23 21:34:01 Encoding: LATIN2 (hungary)