From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | brynk <dnapigkit(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Please help re function packaging... |
Date: | 2004-02-10 11:50:51 |
Message-ID: | 200402101150.51046.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Christoffer Gurell | 2004-02-10 12:01:17 | number of rows in a cursor |
Previous Message | brynk | 2004-02-10 11:18:11 | Please help re function packaging... |