Thank you - On Tue, Jun 18, 2019 at 3:10 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Alexander Farber <alexander.far...@gmail.com> 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
