Stored Procedures in PostgreSQL

[Italus]

hi I'm changind of BD from SQL to postgreSQL and I wanna know how to do this stored procedure in postgres

[CODE=sql]
create Procedure [dbo].[ConsultarDepart amento]
As
BEGIN
Select * From Departamento
END
[/CODE]
thx

[michaelb]

Please read the Posting Guidelines at the top of the Forum, particularly the section about using formatting tags (CODE, etc)

------------------------------------------------------------------------------------
Stored procedures in Postgresql are implemented as functions.
Start with reading these manuals, if you have any problems with implementation post your questions or your code and we'll take it from there.

CREATE FUNCTION
SQL Functions
Porting from Oracle functions
Pl/Pgsql