Guest User

Untitled

a guest
Dec 17th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION mix_table_fields(input_table_name VARCHAR, output_table_name VARCHAR, VARIADIC field_names VARCHAR[])
  2. [...]
  3.  
  4. SELECT mix_table_fields('articles'::VARCHAR, 'output_random_articles'::VARCHAR, array['type'::varchar,'colour'::varchar,'size'::varchar,'price'::varchar]) ;
  5.  
  6. CREATE OR REPLACE FUNCTION public.mix_table_fields(
  7. IN input_table_name character varying,
  8. IN output_table_name character varying,
  9. VARIADIC field_names character varying[])
Add Comment
Please, Sign In to add comment