Re: [despammed] 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 directory information only regarding those 
> filepaths?
> 
> So that I can get
> 
> /var/log
> /var/cache
> /var
> 

test_db=# select * from filepath ;     path
----------------/var/log/foo/var/log/bar/var/cache/foo/var/cache/bar/var/foo
(5 Zeilen)

test_db=# select substring (path, '/.*/') from filepath ; substring
-------------/var/log//var/log//var/cache//var/cache//var/
(5 Zeilen)


test_db=# select trim(trailing '/'from substring (path, '/.*/')) from filepath ;  rtrim
------------/var/log/var/log/var/cache/var/cache/var
(5 Zeilen)




test_db=# select version();                                              version
------------------------------------------------------------------------------------------------------PostgreSQL 7.4.7
oni386-pc-linux-gnu, compiled by GCC i386-linux-gcc (GCC) 3.3.5 (Debian 1:3.3.5-5)
 
(1 Zeile)


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===