
 Hi,

  in our TODO is the item: "Add PL/PgSQL packages".

  I thought about  it and for example Oracle's CREATE  PACKAGE / PACKAGE
 BODY seems  really interesting and modular. IMHO  it's interesting item
 in PostgreSQL TODO, but I think  there a is small collision between the
 schemas and possible package contents referencing:
 
  SELECT xyz.funcname();
         ^^^
 Is it some  function in schema 'xyz' or some  function in package 'xyz'
 in the current schema? Or is needful check both alternatives?
 
 Do you have any experience with it?

    Karel
 
-- 
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

Fri, 28 Nov 2003 14:08:35 +0100
Karel Zak <zakkr@zf.jcu.cz>
PL/SQL packages
Karel Zak writes:

>   in our TODO is the item: "Add PL/PgSQL packages".

I think the interesting part are the package-global variables.  The
name hierarchy seems completely redundant with schemas.

-- 
Peter Eisentraut   peter_e@gmx.net


Fri, 28 Nov 2003 14:35:11 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: PL/SQL packages
On Fri, Nov 28, 2003 at 02:35:11PM +0100, Peter Eisentraut wrote:
> Karel Zak writes:
> 
> >   in our TODO is the item: "Add PL/PgSQL packages".
> 
> I think the interesting part are the package-global variables.  The
> name hierarchy seems completely redundant with schemas.

 Agree, but there is more advantage than package-global variables
 only. The Oracle PACKAGE:
 
    - package is interface definition only and the real functions are
    defined in PACKAGE BODY, it allows you change internal logic, but 
    interface is still same. 

    - package-global cursors

    - package-global variables

    - ??

 Maybe  PACKAGE can  be in  PostgreSQL implemented  as special  a little
 extended schema (like sequence are  special table) and we needn't think
 about something new.

    Karel

-- 
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

Fri, 28 Nov 2003 14:57:43 +0100
Karel Zak <zakkr@zf.jcu.cz>
Re: PL/SQL packages