Re: Stored Procedures

Porting my simple stored procedures to functions seems a little too daunting for me. There doesnt seem to be much direct translation. Stuff about having to supply a return value...I want to return records like a simple select query...or i just want to insert a row into my table with a dozen parameters...I dont want to return anything.

Dennis

----- Original Message -----
From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Date: Thursday, April 10, 2003 4:54 pm
Subject: Re: [NOVICE] Stored Procedures

> search for "functions" and also check out "triggers" and "rules".
>
> Cheers,
> Steve
>
>
> On Thursday 10 April 2003 3:38 pm, bugbug(at)shaw(dot)ca wrote:
> > 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
> >
> >
> > ---------------------------(end of broadcast)--------------------
> -------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
>
> ---------------------------(end of broadcast)----------------------
> -----
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>