[SQL] "reverse()" on strings

[h012]

 Hi,

 CREATE TABLE file (name varchar(255));

 I have a couple of milion filenames. I need to build index based on 
extensions. A couple of possibilities come to mind:

 CREATE INDEX extension_idx ON file (reverse(name));
-- but I didn't find a function called "reverse"

 CREATE INDEX extension_idx ON file (regex_match( '.*(\.[^\.]*)$' );
-- but I didn't find a function called "regex_match" which would return
string matched in brackets ()


 Any ideas ? Help ? Hints ?


   Thanks in advance !

      John


PS: if there is reverse on strings -- where could I find "reverse()" on 
arrays ? - thx

-- 
-- Gospel of Jesus is the saving power of God for all who believe --
               ## To some, nothing is impossible. ##


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]