Search Postgresql Archives

Re: obtaining ARRAY position for a given match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sam Mason wrote:
On Thu, Nov 19, 2009 at 09:46:42AM -0800, Scott Bailey wrote:
We had an idx() function in the _int contrib module. I wonder if it would be useful to write this in C now that _int is deprecated?

Is "idx" really the best name for this? there could be multiple
occurrences of a value in an array (i.e. it's not a set) and hence why I
used "firstidx" for the function name.  If it's replacing an existing
function, then compatibility is a good reason.

Well I used idx() because there was already a idx(int[], int) function with the _int contrib module. Obviously "index" is out of the question. In other languages, it is assumed you are looking for the first index. Some allow you to specify an offset to begin searching at. And some provide another function to get the last index of element.

Here is what other languages are using for similar concept.
PHP - array_search()
Python - index()
Ruby - index()/rindex()
Java - binarySearch()
JavaScript/ActionScript - indexOf()
MySQL - find_in_set()

Scott



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux