test=# SELECT * FROM sal_emp WHERE pay_by_quarter[1:4] *= 10000;
ERROR: Unable to identify an operator '*=' for types 'integer[]' and 'integer'
You will have to retype this query using an explicit cast
There's nothing wrong with the docs (well, at least not with respect to your specific problem), you just need to read them again. Here's a quote from the link you supplied:
"However, this quickly becomes tedious for large arrays, and is not helpful if the size of the array is unknown. Although it is not part of the primary PostgreSQL distribution, there is an extension available that defines new functions and operators for iterating over array values. Using this, the above query could be:" <...snip...> "To install this optional module, look in the contrib/array directory of the PostgreSQL source distribution."
I have no idea how to install contrib/array using debian's package manager, but that's what you need to do.
HTH,
Joe
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
