update some elements in the array

From: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
To: PHP Database <php-db(at)lists(dot)php(dot)net>, PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: update some elements in the array
Date: 2000-07-13 16:48:37
Message-ID: 396DF2E4.456031F3@ec.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

Could someone please tell me that is there anyway that I can update only
a few elements in a Postgres array.

eg; I have an array of text, declared as 'text[]'.

{"1","2","3","4","5"} ==> {"1","2","7","8","9"}

I want to update the last three element without affecting other
elements. I could have done it by retrieving all elements in the array
first and the do a

UPDATE table
SET arr='{"1","2","3","4","5"}'
WHERE blahblah

however, that might be troublesome, so I tried

UPDATE table
SET arr[1]=val1
arr[2]=val2...

but it didn't work. If anyone knows, please tell me. Thanks for the
help.

- Bernie

Attachment Content-Type Size
bernie.huang.vcf text/x-vcard 315 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bernie Huang 2000-07-13 17:55:58 Re: update some elements in the array
Previous Message Henry Lafleur 2000-07-13 13:11:28 RE: join if there, blank if not