Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create function func1(pid integer)
- returns char(20) stable
- as $$
- begin
- ... do stuf
- return 'aaaa';
- end; $$ language plpgsql;
- create view view_client
- as
- --1 view
- select code, name, func1(pid) from client;
- union all
- -- 2 view
- select code, name, 'a' from customer;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement