Re: How to return ARRAY from SQL function?

Thank you -

On Tue, Jun 18, 2019 at 3:10 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Alexander Farber <alexander(dot)farber(at)gmail(dot)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