Re: Oracle Style packages on postgres

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: josh@agliodbs.com
Cc: Tom Lane <tgl@sss.pgh.pa.us>, rmm@sqlisor.com, pgsql-hackers@postgresql.org
Date: 2005-05-10T01:56:53Z
Lists: pgsql-hackers
Josh Berkus wrote:
> B-
> 
> > Just saying "we need Oracle packages" doesn't make it happen. ?I have
> > followed the discussion and I still don't have a clear idea of the exact
> > additions that people want, and without that, nothing is likely to
> > happen. ?I don't even have something for the TODO list at this point.
> 
> That's what I'm trying to help define.
> 
> I think that private variables and private functions need to be part of the 
> definition.

OK, so it seems we need:

	C static/private functions for schemas
	C static/private variables for schemas

Are private variables implemented via the temporary per-session schema?

	nested schemas

What does the standard say?

Is that it?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073