I was reading the concatenation operator earlier.
Postgresql is very neat.
What about deleting an item in the array without
knowing it's position? For example, deleting the item
"12" in the array? Is that possible? Like using
UPDATE array_delete_at(array_find(a,'12'));
where "a" is the column
On Sun, Sep 11, 2005 at 04:02:24PM -0700, Chris Travers wrote:
> Matthew Peter wrote:
> >Is it possible to append and delete (unknown location)
> >items in a list stored in a column? For instance,
> >
> >a column with 'some,values,in,a,list,12,34';
> >
> >Could I [ap|pre]pend and or delete items i
Matthew Peter wrote:
Is it possible to append and delete (unknown location)
items in a list stored in a column? For instance,
a column with 'some,values,in,a,list,12,34';
Could I [ap|pre]pend and or delete items in this list
through pgsql?
prepend:
'value' || ',' || column
append
column
Is it possible to append and delete (unknown location)
items in a list stored in a column? For instance,
a column with 'some,values,in,a,list,12,34';
Could I [ap|pre]pend and or delete items in this list
through pgsql?
_
