[GENERAL] Triggers in Postgres

[Jasbinder Bali]

Hi,
Was wondering if one can write triggers with SQL statements as we have in other RDBMS like SQL Server and oracle.
Can these be written in procedural languages only?
Please put some insight on what needs to be known before working with triggers in postgres.
I've already read the postgres manual in postgres official website.

Regards,
Jas