Re: [SQL] How do I do this?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I have a table with column filepath with contents that look like the > following: .. > Is there anyway to retrieve the directory information only regarding those > filepaths? SELECT rtrim(substring(filepath from '.+/'),'/') FROM mytable; - -- Gr

Re: [despammed] [SQL] How do I do this?

am 23.03.2005, um 12:37:54 -0500 mailte Wei Weng folgendes: > I have a table with column filepath with contents that look like the > following: > > filepath > == > /var/log/foo > /var/log/bar > /var/cache/foo > /var/cache/bar > /var/foo > /var/bar > > Is there anyway to retrieve the

[SQL] How do I do this?

I have a table with column filepath with contents that look like the following: filepath == /var/log/foo /var/log/bar /var/cache/foo /var/cache/bar /var/foo /var/bar Is there anyway to retrieve the directory information only regarding those filepaths? So that I can get /var/log /var/c