Procedural languages aren't built into Postgres. They are offered by loadable modules. Please refer to the documentation for the PL in question for details about the syntax and how the AS clause is interpreted by the PL handler.
There are two procedural languages available with the standard Postgres distribution (PLTCL and PLSQL), and other languages can be defined. Refer to Procedural Languages for more information.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.