Re: [HACKERS] array manipulations

Peter Blazso <blazso(at)deltav(dot)hu> writes:
> If you are interested, I could extend its functionality to other types
> as well and send this small pack to you. For this, however I should know
> more about how Postgres manages types internally...

I think it should be possible to make a type-independent version of that
code, and if you want to do so it'd be a great extension.

How does it look to the user? Something like

UPDATE table SET arrayfield = arrayInsert(arrayfield, index, newval)

UPDATE table SET arrayfield = arrayDelete(arrayfield, index)

I suppose? What do you do about multi-dimensional arrays?

One thing a number of people have complained about is that the natural
way to extend an array is

UPDATE table SET arrayfield[n+1] = newval

if arrayfield currently has n entries. The array assignment code ought
to handle this case but doesn't. I don't think it would be a huge fix
but I haven't looked at the code enough to understand what would need
to change.

regards, tom lane