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.