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