| 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: | Whole Thread | Raw Message | 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 |
| 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 |