Postgres Pro
Downloads
Home   >   mailing lists

Re: obtaining ARRAY position for a given match - Mailing list pgsql-general

From Scott Bailey
Subject Re: obtaining ARRAY position for a given match
Date
Msg-id 4B057D37.6010807@comcast.net
Whole thread Raw
In response to Re: obtaining ARRAY position for a given match  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: obtaining ARRAY position for a given match  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
>    FROM generate_series(array_lover($1,1),array_upper($1,1)) g(i)

Pavel,

Don't get me wrong, I enjoy coding, but I think you've taken it too far
here ;)

Yes, definitely more effective for large arrays. Thanks. Would probably
be a good snippet for the wiki.

Scott

pgsql-general by date:

Previous
From: Raimon Fernandez
Date:
Subject: Re: Encoding using the Frontend/Backend Protocol TCP/IP
Next
From: Merlin Moncure
Date:
Subject: Re: obtaining ARRAY position for a given match