I looked at the postgres website and to add a integer to a intarray it says int + int. I have a int array in a table and I eventually want to insert the array with another value added to it into another table. So testing with a select statement I am not sure where I am messing up.
So a am doing:
SELECT myarray + 9::integer from foo ERROR: operator does not exist: smallint + integer
What am I missing. It looks just like the postgres website on intarrays from 9.1 postgres.