Hi,
position(substring in string)
as listed here:
locates sub string in a string.
It doesn't support locateing the substring from the back.
For example:
position('om' in 'Tomomas')
gives 2
But if I want to locate the first occurance from the back of the string it's impossible/
My suggestion is to create a function
position(substring in string,order)
where order can be: begin, end
and it will find the string according to this parameter.
This is pretty easy to implement and should be a part of the PostgreSQL tools.
similar fuctionality exists in trim function where user can specify leading or taling parameter
