Re: Stored Procedures

Date sent: Fri, 11 Apr 2003 15:04:34 -0600
From: bugbug(at)shaw(dot)ca
Subject: Re: [NOVICE] Stored Procedures
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Copies to: pgsql-novice(at)postgresql(dot)org

Its hard to know what you want but,
> Porting my simple stored procedures to functions seems a little too daunting for me.
If they are simple you should be able to write the functions in SQL, you can get quite far
with a few case statements

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...

Check out views for this sort of thing

or i just want to insert a row into my table with a dozen parameters...

I dont want to return anything.
>
> Dennis

Cheers

Paul Butler
>
>
> ----- 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org