Re: Problems with arrays

Joe Conway writes:
> While perhaps misleading, the answer is correct. You are appending array
> elements to a NULL array, so the answer should be null. I think what you
> really want here is:
>
> regression=# update test_arr set ratecardlist = '{3,4,5}' where id = 1;
> UPDATE 1
> regression=# select * from test_arr;
> id | ratecardlist
> ----+--------------
> 1 | {3,4,5}
> (1 row)
>
> This actually replaces the NULL array instead of appending to it.
>
> HTH,

It does indeed help! Many thanks for that.

<mischevous grin>
Perhaps this ought to be documented a little more clearly?
</mischevous grin>

Regards,
Harry.