Order by random()?
#14609
Replies: 2 comments 1 reply
-
In the interim, to keep moving, I have created a function CREATE OR REPLACE function fetch_random_words()
returns setof words
language sql
as $$
SELECT * FROM words TABLESAMPLE BERNOULLI (5)
$$; |
Beta Was this translation helpful? Give feedback.
0 replies
-
Is there any update on if this is likely to be added? |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Postgres allows you to fetch a random subset of rows either by
or
How can I achieve either using the supabase client?
Beta Was this translation helpful? Give feedback.
All reactions