tags:

views:

33

answers:

2
Q: 

Stored procedures and Triggers in PostgreSQL

I never used these two features in PostgreSQL. Which language is used to write stored procedures and triggers in PGSQL? Is it the same that Oracle or SQL Server follows or it is C?

+2  A: 

Far more common for writing functions is pl/pgsql but you can use C if you really want to.

Nev Stokes  2010-10-29 15:33:01
Is there any option to use standard Oracle or SQL Server style?
RPK  2010-10-29 15:33:56
Not that I know of. In addition to the core procedural languages there are some third party ones: http://www.postgresql.org/docs/8.0/interactive/external-projects.html
Nev Stokes  2010-10-29 15:37:37
Way more appropriate link would be: http://www.postgresql.org/docs/current/static/xplang.html
Milen A. Radev  2010-10-30 11:48:03
+1  A: 

It's called PL/PgSQL and is similar to others. http://www.postgresql.org/docs/8.1/static/plpgsql.html

You can call C code functions as well.

mootinator  2010-10-29 15:33:20

related questions

In WPF Style, How can Trigger access a son Element of the Element it is attatched
How to constrain a database table so only one row can have a particular value in a column?
Can you use routed events with a MultiTrigger?
T-SQL - Is there a way to disable a trigger in the scope of a transaction?
Perforce trigger to deny submission of unchanged files?
Triggers vs Constraints
Using WPF, what is the best method to update the background for a custom button control?
Javascript: Trigger action on function exit
Database Duplicate Value Issue ( Filtering Based on Previous Value)
Best Method to Spawn Process from SQL Server Trigger
How to check if a trigger is invalid?
SQL - How do you compare a CLOB
SQL Server 2005 multiple database deployment/upgrading software suggestions
MySQL triggers + replication with multiple databases.
T-SQL triggers firing a "Column name or number of supplied values does not match table definition" error
How do you priortize multiple triggers of a table?
MySQL Trigger & Stored Procedure Replication
Setting Up MySQL Triggers
How can I get the definition (body) of a trigger in SQL Server?
PLS-00306 error on call to cursor
Trigger without a transaction?
Database triggers
Building an auditing system; MS Access frontend on SQL Server backend.
Timer-based event triggers
Throw Error In MySQL Trigger