Re: list manipulation at column level

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: list manipulation at column level
Дата
Msg-id 4324B780.9040107@travelamericas.com
обсуждение исходный текст
Ответ на list manipulation at column level  (Matthew Peter <survivedsushi@yahoo.com>)
Ответы Re: list manipulation at column level  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
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 || ',' ||'value'

Delete would require some regular expressions-- check the manual on these.

Or you could write a Perl function.

However, this strikes me as quite denormalized....

Best Wishes,
Chris Travers
Metatron Technology Consulting


В списке pgsql-general по дате отправления:

Предыдущее
От: Matthew Peter
Дата:
Сообщение: list manipulation at column level
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: list manipulation at column level