emafriedrich/randomelement.sql

Created June 22, 2024 11:28

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/emafriedrich/666c968335135a1a44a3c09b3a0d98cb.js"></script>
Save emafriedrich/666c968335135a1a44a3c09b3a0d98cb to your computer and use it in GitHub Desktop.

Download ZIP

Select random array element PostgreSQL

Raw

randomelement.sql

update table set your_colum = (array['foo', 'bar', 'baz'])[floor(random() * 3 + 1)]; -- replace 3 with your array length

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment