Stored Procedures

From: bugbug(at)shaw(dot)ca
To: pgsql-novice(at)postgresql(dot)org
Subject: Stored Procedures
Date: 2003-04-10 22:38:58
Message-ID: beab9be333.be333beab9@shaw.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Im new to postgre...and Im trying to make the leap from ms sql(was kinda new there too! )

How do I implement ms sql style stored procedures in postgre ? I have ms sql stored procedures like the following to insert data into a db that is called from a web form:

CREATE PROCEDURE pr_Wellogs_Insert
@iWELL_NUM int = NULL,
@sOWNER nvarchar(60) = NULL,
@siWELL_LOT smallint = NULL,
@stFrom smallint = NULL,
@stTO smallint = NULL

AS

INSERT WELLOGS
(
[WELL_NUM],
[OWNER],
[WELL_LOT]
)
VALUES
(
@iWELL_NUM,
@sOWNER,
@siWELL_LOT

if (@stFrom <> ' ')
begin insert stratigraphy3
(
[well_num],
[from],
[to]
)
values
(
@iWELL_NUM,
@stFrom,
@stTO
)
end
return

------
In pgadmin I cant even find anything called stored procedures. Also...how do I implement @@identity in postgre ?

Thanks!
Dennis

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-04-10 22:49:46 Re: Stored Procedures
Previous Message Don Patou 2003-04-10 21:42:42 looking for a script to compare databases