<div><div dir="rtl"><div>I never expected it to be implemented now.. I understand that there are policies and priorities<br><br></div>
<div>I tried to find a feature request chanle but there is none...</div>
<div>I don't know how the postresql team decied what is on the "to do list" and what is not.</div>
<div>This is a feature which I think people will find usefull and it doesn't seem like a lot of work to implement it.</div></div><section class="cust_msg_end"></section><blockquote style="margin:0;margin-bottom:20px;border-top:1px solid #e0e0e0;"><br>ב מרץ 28, 2017 19:42, David G. Johnston כתב:<blockquote style="margin:0;margin-bottom:20px;border-top:1px solid #e0e0e0"><div dir="ltr"><div style="font-family:arial,helvetica,sans-serif"><span style="font-family:arial,sans-serif">On Tue, Mar 28, 2017 at 7:09 AM, Adrian Klaver </span><span dir="ltr" style="font-family:arial,sans-serif"><<a href="mailto:adrian(dot)klaver(at)aklaver(dot)com" target="_blank">adrian(dot)klaver(at)aklaver(dot)com</a>></span><span style="font-family:arial,sans-serif"> wrote:</span><br></div><div><div><blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 03/28/2017 12:29 AM, Ron Ben wrote:<br>
<blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Here is a refer to the stackoverflow question:<br>
<br>
<a href="http://stackoverflow.com/questions/42974822/find-sub-string-position-from-the-end-of-string-in-postgresql" rel="noreferrer" target="_blank">http://stackoverflow.com/quest<wbr>ions/42974822/find-sub-string-<wbr>position-from-the-end-of-<wbr>string-in-postgresql</a><br>
<br>
it carry another example and the solution however I still think that<br>
this fuctionality should be avliable in a build-in postgresql function.<br>
<br>
</blockquote>
<br></span>
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).</blockquote><div><br></div><div><div style="font-family:arial,helvetica,sans-serif">Not technically frozen but if the implementing patch isn't already in the commit-fest system it isn't getting into 10. All feature freeze means at this point is that anything currently in the commit-fest system that doesn't get committed by that time it going to be punted to 11.</div></div><div> </div><blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> 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:<br>
<br>
<a href="https://www.postgresql.org/account/login/?next=/account/submitbug/" rel="noreferrer" target="_blank">https://www.postgresql.org/acc<wbr>ount/login/?next=/account/subm<wbr>itbug/</a><br>
<br></blockquote><div><br></div><div><div style="font-family:arial,helvetica,sans-serif">This is a poor recommendation given that its absence is not a bug.</div></div><div><br></div><blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
or<br>
<br>
post to the --hackers list:<br>
<br>
<a href="https://www.postgresql.org/list/pgsql-hackers/" rel="noreferrer" target="_blank">https://www.postgresql.org/lis<wbr>t/pgsql-hackers/</a></blockquote><div><br></div><div style="font-family:arial,helvetica,sans-serif">Maybe not ideal but we don't have any kind of "feature requests" lists so its either -hackers or -general.</div><div style="font-family:arial,helvetica,sans-serif"><br></div><div style="font-family:arial,helvetica,sans-serif">I'd even go so far as to say "-general" is better because you get more eyes on the request for people to give it support and, apparently in this case, finding people to do the leg work of writing a patch.</div><div style="font-family:arial,helvetica,sans-serif"><br></div><div style="font-family:arial,helvetica,sans-serif">David J.</div><div style="font-family:arial,helvetica,sans-serif"><br></div></div></div></div>
<br></blockquote></blockquote><br></div>