[PHP-DB] update some elements in the array From: Bernie Huang (bernie.huang <email protected>)
Date: 07/13/00

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>