Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
trigger
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
drop table if exists reach cascade; drop table if exists rp cascade; drop function if exists delete_reach() cascade; CREATE TABLE reach ( id integer NOT NULL, rp integer ); CREATE TABLE rp ( id integer NOT NULL ); INSERT INTO reach (id, rp) VALUES (1,10), (2,20), (3,30), (4,40); INSERT INTO rp (id) VALUES (10), (20), (30),(40); CREATE VIEW vw_reach AS select * from reach; create or replace function delete_reach() returns trigger as ' begin DELETE FROM reach WHERE reach.id = old.id; DELETE FROM rp WHERE rp.id = old.rp; return old; end; ' language plpgsql; create trigger delete_reach_trigger instead of delete on vw_reach for each row execute procedure delete_reach(); delete from vw_reach where id = 2; select * from rp;
absolute service time: 1,17 sec
edit mode
|
history
id
1
10
2
30
3
40