Re: How to get normalized data from tekst column - Mailing list pgsql-general

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.