Re: String manipulation

David Olbersen wrote:
> I have an *UGLY* solution that might give you or others some ideas...
>
> SELECT
>   substring(
>     split_part( path, ':', 2 )
>     from
>     position( ' ' in split_part( path, ':', 2 ) ) + 1
>   )
> FROM paths;
>

That solution was pretty much what I was thinking. An alternative:

SELECT substring(path from position(' ' in path) + 1)
FROM (SELECT split_part( path, ':', 2 ) AS path FROM paths) AS ss;

Joe