On 03/28/2017 12:29 AM, Ron Ben wrote:
Here is a refer to the stackoverflow question: http://stackoverflow.com/questions/42974822/find-sub-string-position-from-the-end-of-string-in-postgresql it carry another example and the solution however I still think that this fuctionality should be avliable in a build-in postgresql function.
This would be a new feature and Postgres only introduces new features in new major version releases. The next major release is 10 and it is the latter stages of development. Not sure if there is a feature freeze on yet or not. In any case it will not be released for production until fall sometime(best guess, I have nothing to do with release schedule). If it did not make it into that release you are looking another year out. So if this is something you need soon, then I would say the solution would be to create your own function using the suggestions provided. If you really want this as a built in, regardless of when it is done I would suggest either filing bug:
https://www.postgresql.org/account/login/?next=/account/submitbug/ or post to the --hackers list: https://www.postgresql.org/list/pgsql-hackers/ -- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general