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 e6DHuh070924 for ; Thu, 13 Jul 2000 13:56:43 -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 KAA31538; Thu, 13 Jul 2000 10:56:03 -0700 Message-ID: <396E02AE.DE31FF18@ec.gc.ca> Date: Thu, 13 Jul 2000 10:55:58 -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: Jouni Ahto CC: PHP Database , PGSQL-SQL Subject: Re: update some elements in the array References: Content-Type: multipart/mixed; boundary="------------33D79C88E6272C2A13F5A791" X-Archive-Number: 200007/145 This is a multi-part message in MIME format. --------------33D79C88E6272C2A13F5A791 Content-Type: text/plain; charset=iso-8859-15 Content-Transfer-Encoding: 7bit Jouni Ahto wrote: > On Thu, 13 Jul 2000, Bernie Huang wrote: > > > 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. > > What does "it didn't work" in this case exactly mean? > > Did some testing with postgres, results; > > create table test (arr text[]); > insert into test values ('{"1","2","3","4","5"}'); > select * from test; > arr > ----------------------- > {"1","2","3","4","5"} > (1 row) > update test set arr[4]='8', arr[2]='9'; > select * from test; > arr > ----------------------- > {"1","9","3","8","5"} > (1 row) > > So, updating arrays definitely works. Are you having a syntax error > somewhere or what? > > -- Jouni Ahto Thanks. I forgot the quote...' ' (Man, that quote just drives me nuts...) - Bernie --------------33D79C88E6272C2A13F5A791 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 --------------33D79C88E6272C2A13F5A791--