Re: Request to add feature to the Position function

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ron Ben <ronb910(at)walla(dot)co(dot)il>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Brian Dunavant <brian(at)omniti(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Request to add feature to the Position function
Date: 2017-03-29 14:07:11
Message-ID: 3b3bc528-45bd-f0b6-8c9c-e7ad2f774990@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 03/29/2017 04:06 AM, Ron Ben wrote:
> I never expected it to be implemented now.. I understand that there are
> policies and priorities
>
> I tried to find a feature request chanle but there is none...

This list and and/or --hackers would be that channel.

> I don't know how the postresql team decied what is on the "to do list"
> and what is not.

If you scan the Todo list:

https://wiki.postgresql.org/wiki/Todo

most of the items reference messages to --general or --hackers, where
enough people expressed interest in the feature. To go from there to
done will require someone willing to do the coding.

I will start the ball rolling by saying I am interested in the feature.
Unfortunately I do not have the coding skills to make it happen.

> This is a feature which I think people will find usefull and it doesn't
> seem like a lot of work to implement it.
>
>
> ב מרץ 28, 2017 19:42, David G. Johnston כתב:
>
> On Tue, Mar 28, 2017 at 7:09 AM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>wrote:
>
> 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
> <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).
>
>
> ​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.​
>
>
> 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/
> <https://www.postgresql.org/account/login/?next=/account/submitbug/>
>
>
> This is a poor recommendation given that its absence is not a bug.​
>
> or
>
> post to the --hackers list:
>
> https://www.postgresql.org/list/pgsql-hackers/
> <https://www.postgresql.org/list/pgsql-hackers/>
>
>
> Maybe not ideal but we don't have any kind of "feature requests"
> lists so its either -hackers​ or -general.
>
> 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.
>
> David J.
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Smith 2017-03-29 14:38:52 Logical Replication: adjacent COMMIT messages with the wrong StartLSN
Previous Message Tom Lane 2017-03-29 13:59:41 Re: Using relations in the SELECT part