By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

Stored Procedures in PostgreSQL

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

Expand|Select|Wrap|Line Numbers
  1. create Procedure [dbo].[ConsultarDepartamento]
  2. As
  3.     BEGIN
  4.         Select * From Departamento
  5.     END
  6.  
thx
May 25 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
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
May 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.