On Sun, 17 Aug 2003, andrea gelmini wrote: > 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
I see from those docs: 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: SELECT * FROM sal_emp WHERE pay_by_quarter[1:4] *= 10000; --- This is talking about an extension that's not part of the primary distribution as described in the paragraph before the example. I believe it's refering to contrib/array. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster