Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. create type myenum
  2. as enum (
  3. 'one',
  4. 'two',
  5. 'three',
  6. 'four'
  7. );
  8.  
  9. create table testtable (
  10. id integer PRIMARY KEY,
  11. name myenum
  12. );
  13.  
  14.  
  15. create or replace function random_enum(
  16. relation_name_in text
  17. )
  18. returns text
  19. language sql strict
  20. as $$
  21. select e.enumlabel::text
  22. from pg_type t
  23. join pg_enum e on t.oid = e.enumtypid
  24. join pg_catalog.pg_namespace n on n.oid = t.typnamespace
  25. where t.typname = lower(relation_name_in)
  26. order by random()
  27. limit 1;
  28. $$ ;
  29.  
  30. insert into testtable (id, name) values (1, random_enum('myenum')::myenum);
  31.  
  32. select * from testtable;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement