2016-03-08 15:59 GMT+02:00 Alexander Farber :
> Here 1-pass version, if you have improvement suggestions, you are welcome -
>
My variant:
CREATE OR REPLACE FUNCTION arrexcept(anyarray, anyarray) RETURNS anyarray
AS $arrexcept$
SELECT array_agg(un) FROM (
SELECT un, row_number() OVER (PARTI
Here 1-pass version, if you have improvement suggestions, you are welcome -
DROP FUNCTION IF EXISTS words_array_subtract(anyarray, anyarray);
CREATE OR REPLACE FUNCTION words_array_subtract(from_array anyarray,
remove_array anyarray)
RETURNS anyarray AS
$func$
DECLARE
Hello again,
I could not find a solution neither
at http://postgres.cz/wiki/Array_based_functions
nor at https://github.com/JDBurnZ/postgresql-anyarray
So I have written my own stored function
to subtract one non-unique array from another
(like swapping tiles in a word game):
DROP FUNCTION IF E
Hi
2016-03-06 18:41 GMT+01:00 Alexander Farber :
> Thank you, but shouldn't I better use FOREACH for my task?
>
>
SQL based solution (functional based) solution can be faster and shorter.
PLpgSQL is nice language, but what you can do about arrays functionally,
you should to do :). Usually it is s
Thank you, but shouldn't I better use FOREACH for my task?
On Sun, Mar 6, 2016 at 6:34 PM, bricklen wrote:
> On Sun, Mar 6, 2016 at 9:22 AM, Alexander Farber <
> alexander.far...@gmail.com> wrote:
>
>> could someone please recommend the most efficient way subtracting
>> elements of one array fro
On Sun, Mar 6, 2016 at 9:22 AM, Alexander Farber wrote:
> could someone please recommend the most efficient way subtracting elements
> of one array from the other in PostgreSQL 9.5?
>
There are quite a few examples of array functions at
http://postgres.cz/wiki/Array_based_functions, probably wor
Hello,
could someone please recommend the most efficient way subtracting elements
of one array from the other in PostgreSQL 9.5?
Should I create a new array or can I work on the existing one (and if the
latter - will FOREACH work well when elements are removed "from under its
feet"?).
Both array
