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 variablesonly. The Oracle PACKAGE:   - package is interface
definitiononly and the real functions are   defined in PACKAGE BODY, it allows you change internal logic, but
interfaceis still same. 
 
   - package-global cursors
   - package-global variables
   - ??
Maybe  PACKAGE can  be in  PostgreSQL implemented  as special  a littleextended schema (like sequence are  special
table)and we needn't thinkabout something new.
 
   Karel

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