Re: 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