PostgreSQL PL/pgSQL random value from array of values April 2, 2024 by Tarik Try this one: select (array['Yes', 'No', 'Maybe'])[floor(random() * 3 + 1)];