On Wed, Sep 21, 2005 at 06:56:36PM -0700, Matthew Peter wrote:
> How is it possible to delete an item from a single
> dimension varchar[] array? Lets say it has the values
> {1,2,3,4,5,6}... how do i delete at position [4]?
I'm not sure if there's a better way, but you could concatenate the
slices adjacent to the position you want to delete:
test=> SELECT a FROM foo;
a
---------------
{1,2,3,4,5,6}
(1 row)
test=> UPDATE foo SET a = a[1:3] || a[5:6];
UPDATE 1
test=> SELECT a FROM foo;
a
-------------
{1,2,3,5,6}
(1 row)
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
