[dbenhur]

The default stored procedure language is PL/pgSQL http://www.postgresql.org/docs/9.3/static/plpgsql.html and has been available in Postgres almost forever.

[nousernamesleft]

Those are functions, not stored procedures.