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