Message-ID: <00b501c31a86$6a6a3130$4706050a@stevenc>
From: "Steven Chau" <stevenc@astri.org>
To: <pgsql-sql@postgresql.org>
Subject: Newbie question: How to CREATE FUNCTION
Date: Thu, 15 May 2003 10:04:54 +0800
Organization: Astri
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


Hi,

I am new to PostgreSQL. So, please forgive my ignorane.

Can anyone tell me how to create a FUNCTION in PostgreSQL that performs the
same duty as the following MsSQL stored procedure?


*********************************************************
Create PROCEDURE AddEmployee
    @Name                         NVARCHAR(255)
    ,@Title                    NVARCHAR(255)
    ,@strErr                    VARCHAR(255)     OUTPUT

AS
BEGIN

    /* ~~~  Add the employee into the Employees table ~~~ */
    INSERT INTO     Employees
         (     name
              ,title
         )
    VALUES
         (     @Name
              ,@Title
         )


    /* ~~~  Error checking ~~~ */
    IF( @@rowcount = 0 )
    BEGIN
         SELECT @strErr = 'Errors adding the new employee.\n'
         RETURN -1
    END
    / * ~~

    /* ~~~  Return the auto id through the OUTPUT parameter ~~~ */
    SELECT @strErr = CONVERT(VARCHAR(255), @@IDENTITY)
    RETURN 0

END
*********************************************************


Can you also tell me how to add a new language (if necessary) like pgsql
into PostgreSQL? Pointers to learning pgsql will also be appreciated.

Thanks a lot in advance!


Steven