Harald,
Thank you.
> The query
>SELECT id, a[1] AS name, a[2] AS percent
>FROM ( SELECT id, regexp_split_to_array(regexp_split_to_table(comment, ',
>*'), '\W+') AS a
> FROM project ) AS dummy
>should work un every halfway recent PostgreSQL version - dunno about 8.1.
I tried it but got error in 8.1:
ERROR: function regexp_split_to_table(text, "unknown") does not exist
HINT: No function matches the given name and argument types. You may need
to add explicit type casts.
how to get data in 8.1 ?
Andrus.