Anyone please help... I'm a newbie on creating functions in postgresql.

Here is an oracle package that I'm trying to port to postgresql:

CREATE OR REPLACE  PACKAGE BODY NewsPkg.NewsTools
AS
   PROCEDURE del_news (i_id IN VARCHAR2)
   IS
   BEGIN
      DELETE FROM tbl_news_type
            WHERE uniqueid = i_id;

      DELETE FROM tbl_news
            WHERE uniqueid = i_id;
   END del_news;

   PROCEDURE upd_newstype
   IS
      CURSOR cur_news
      IS
         SELECT   uniqueid
             FROM tbl_news_type
            WHERE mother_id IS NULL
         GROUP BY uniqueid;

      v_id   tbl_news_type.uniqueid%TYPE;
   BEGIN
      OPEN cur_news;

      LOOP
         FETCH cur_news INTO v_id;
         upd_mothernews (v_id);
         COMMIT;
      END LOOP;

      CLOSE cur_news;
   END upd_newstype;
END NewsTools;

Can anyone help me on how this oracle package would look like in 
postgresql... I would really appreciate it if someone could show me even 
the synopsis of this code in postgresql. I've been trying all sorts of 
ways to come up with the code in postgresql but when I this command:
    select NewsTools.del_news('20040111DN001869');
I get this error:
    ERROR:  Namespace "NewsTools" does not exist

Tnx,
Darius







Anyone please help... I'm a newbie on creating functions in postgresql.

Here is an oracle package that I'm trying to port to postgresql:

CREATE OR REPLACE  PACKAGE BODY NewsPkg.NewsTools 
AS
   PROCEDURE del_news (i_id IN VARCHAR2)
   IS
   BEGIN
      DELETE FROM tbl_news_type
            WHERE uniqueid = i_id;

      DELETE FROM tbl_news
            WHERE uniqueid = i_id;
   END del_news;

   PROCEDURE upd_newstype
   IS
      CURSOR cur_news
      IS
         SELECT   uniqueid
             FROM tbl_news_type
            WHERE mother_id IS NULL
         GROUP BY uniqueid;

      v_id   tbl_news_type.uniqueid%TYPE;
   BEGIN
      OPEN cur_news;

      LOOP
         FETCH cur_news INTO v_id;
         upd_mothernews (v_id);
         COMMIT;
      END LOOP;

      CLOSE cur_news;
   END upd_newstype;
END NewsTools;

Can anyone help me on how this oracle package would look like in
postgresql... I would really appreciate it if someone could show me
even the synopsis of this code in postgresql. I've been trying all
sorts of ways to come up with the code in postgresql but when I this
command:
    select NewsTools.del_news('20040111DN001869');
I get this error:
    ERROR:  Namespace "NewsTools" does not exist

Tnx,
Darius
Mon, 09 Feb 2004 16:58:04 +0800
Darius <brynk13@netscape.net>
Please help re function packaging...