Reputation: 14159
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?
Upvotes: 0
Views: 585
Reputation: 5745
if your are working with text data in stored procedures Perl will be very usefull. I myself use PL/PERL.
Upvotes: 0
Reputation: 17388
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.
Upvotes: 1
Reputation: 9819
Far more common for writing functions is pl/pgsql but you can use C if you really want to.
Upvotes: 2