Kevin Duffy wrote:
> Just testing the regexp_string_to_array
>
> This SQL
> select description, regexp_string_to_array(description::text , E'\\s+' )
> as optdesc, securitytype
> from xxxxxx where type = 'B' order by 1
>
> produced this error:
>
> ERROR: function regexp_string_to_array(text, text) does not exist
> SQL state: 42883
> Hint: No function matches the given name and argument types. You may
> need to add explicit type casts.
> Character: 21
Are you running 8.3?