Skip to content
This repository was archived by the owner on Dec 15, 2022. It is now read-only.

Trigger / Procedure related keywords #66

Open
Richie765 opened this issue Jun 30, 2017 · 3 comments
Open

Trigger / Procedure related keywords #66

Richie765 opened this issue Jun 30, 2017 · 3 comments

Comments

@Richie765
Copy link

Richie765 commented Jun 30, 2017

Could trigger / procedure related keywords be implemented?
Here are a couple of them:

before delete on
after delete on
before update on
after update on
before insert on
after insert on

for each row
execute procedure
returns trigger
return
language plpgsql

perform
raise exception

if
elsif
else
end if

Thanks!

@winstliu
Copy link
Contributor

winstliu commented Jul 8, 2017

Do you know which SQL variants support these keywords?

@Cxarli
Copy link
Contributor

Cxarli commented Jul 11, 2017

Seems to be PostgreSQL (at least language plpgsql is)

@Richie765
Copy link
Author

The list was meant for PostgreSQL, but most of them are also valid for MySQL.
As far as I can tell, the following ones are PostgreSQL specific:

execute procedure
returns trigger
return
language plpgsql
perform
raise exception

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

3 participants