Thank you -
On Tue, Jun 18, 2019 at 3:10 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Alexander Farber <alexander.farber@xxxxxxxxx> writes:
> And then I shuffle the letters by -
> CREATE OR REPLACE FUNCTION words_shuffle(in_array text[])
> RETURNS text[] AS
> $func$
> SELECT array_agg(x ORDER BY RANDOM()) FROM UNNEST(in_array) x;
> $func$ LANGUAGE sql STABLE;
Hmm ... that's not really "stable", since it depends on random()
which is volatile.
I was wondering that too, but assumed it is maybe STABLE because the function does not modify any tables.
I will remove the STABLE keyword now
Regards
Alex
