Received: from sandtstudent.pyr.ec.gc.ca (fwvan1.pyr.ec.gc.ca [199.212.20.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e6DGnE053635 for ; Thu, 13 Jul 2000 12:49:14 -0400 (EDT) Received: from ec.gc.ca (IDENT:huangb@sandtstudent [131.235.150.249]) by sandtstudent.pyr.ec.gc.ca (8.9.3/8.9.3) with ESMTP id JAA31437; Thu, 13 Jul 2000 09:48:41 -0700 Message-ID: <396DF2E4.456031F3@ec.gc.ca> Date: Thu, 13 Jul 2000 09:48:37 -0700 From: Bernie Huang Organization: Environment Canada X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: PHP Database , PGSQL-SQL Subject: update some elements in the array Content-Type: multipart/mixed; boundary="------------1D3B2833FCDCFE8764AB9E84" X-Archive-Number: 200007/144 This is a multi-part message in MIME format. --------------1D3B2833FCDCFE8764AB9E84 Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: 7bit 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 --------------1D3B2833FCDCFE8764AB9E84 Content-Type: text/x-vcard; charset=iso-8859-15; name="bernie.huang.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Bernie Huang Content-Disposition: attachment; filename="bernie.huang.vcf" begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700-1200 West 73 Ave.;Vancouver;BC;V6P 6H9;Canada version:2.1 email;internet:bernie.huang@ec.gc.ca title:Programmer x-mozilla-cpt:;0 fn:Bernie Huang end:vcard --------------1D3B2833FCDCFE8764AB9E84--