Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. create function func1(pid integer)
  2. returns char(20) stable
  3. as $$
  4. begin
  5. ... do stuf
  6. return 'aaaa';
  7. end; $$ language plpgsql;
  8.  
  9. create view view_client
  10. as
  11. --1 view
  12. select code, name, func1(pid) from client;
  13. union all
  14. -- 2 view
  15. select code, name, 'a' from customer;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement