PostgreSQL PL/pgSQL random value from array of values

arrays postgresql random plpgsql postgresql-9.2
Mo J. Mughrabi picture Mo J. Mughrabi · Jan 13, 2013 · Viewed 10.8k times · Source

How can I declare an array like variable with two or three values and get them randomly during execution? 

a := [1, 2, 5] -- sample sake
select random(a) -- returns random value

Any suggestion where to start?

Answer

Andrey Sarul picture Andrey Sarul · Oct 23, 2018

Try this one:

select (array['Yes', 'No', 'Maybe'])[floor(random() * 3 + 1)];

Related questions

Check if value exists in Postgres array

Using Postgres 9.0, I need a way to test if a value exists in a given array. So far I came up with something like this: select '{1,2,3}'::int[] @> (ARRAY[]::int[] || value_variable::int) But I keep thinking there …

Read More
How to turn a json array into rows in postgres

I have a json array stored in my postgres database. The json looks like this: [ { "operation": "U", "taxCode": "1000", "description": "iva description", "tax": "12" }, { "operation": "U", "taxCode": "1001", "description": "iva description", "tax": "12" }, { "operation": "U", "taxCode": "1002", "description": "iva description", "tax": "12" } ] Now I need to …

Read More
Loop over array dimension in plpgsql

In plpgsql, I want to get the array contents one by one from a two dimension array. DECLARE m varchar[]; arr varchar[][] := array[['key1','val1'],['key2','val2']]; BEGIN for m in select arr LOOP raise NOTICE …

Read More