I'm trying to extract element of a directory path stored in the db with substring
and i want to extract the 1st, 2nd and 3rd parts
1st = help, 2nd = support, 3rd = index
but I can't get the regular expressions correct.
Any ideas on what I need to do.
select substring(data,'????') from paths
pgsql-general by date
|Next:||From: Carlos Moreno||Date: 2004-08-25 04:14:56|
|Subject: Re: Deadlocks caused by referential integrity checks|
|Previous:||From: Tatsuo Ishii||Date: 2004-08-25 02:21:32|
|Subject: Re: UTF-8 and LIKE vs =|