Re: Please help re function packaging...

On Tuesday 10 February 2004 11:18, brynk wrote:
> 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

We don't have packages.

> PROCEDURE del_news (i_id IN VARCHAR2)

These will be functions rather than procedures.

> 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

Post one of your functions with the Oracle equivalent and someone will be able
to point out any problems.

> but when I this
> command:
> select NewsTools.del_news('20040111DN001869');
> I get this error:
> ERROR: Namespace "NewsTools" does not exist

And does the namespace (i.e. schema) NewsTools exist?

--
Richard Huxton
Archonet Ltd