Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TRIGGER IF EXISTS *nazwa* ON *tabela*;
- CREATE OR REPLACE FUNCTION *tabela*.*funkcja*
- RETURNS TRIGGER AS
- $$
- DECLARE ...;
- BEGIN
- ...
- RETURN new;
- END;
- $$ LANGUAGE PLpgSQL;
- CREATE TRIGGER *nazwa*
- BEFORE INSERT ON *tabela*
- FOR EACH ROW / FOR EACH STATEMENT
- EXECUTE PROCEDURE *tabela*.*funkcja*;
- CREATE OR REPLACE VIEW daneDoWysylki AS
- SELECT z.idzamowienia, z.datarealizacji, k.nazwa, k.ulica, k.miejscowosc, k.kod
- FROM zamowienia z JOIN klienci k USING(idklienta);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement