Re: procedure returns a tuple - Mailing list pgsql-hackers

From Karel Zak
Subject Re: procedure returns a tuple
Date
Msg-id Pine.LNX.3.96.1000404135554.6641C-100000@ara.zf.jcu.cz
Whole thread Raw
In response to Re: procedure returns a tuple  (wieck@debis.com (Jan Wieck))
List pgsql-hackers
On Mon, 3 Apr 2000, Jan Wieck wrote:

> Karel Zak wrote:
> 
> > I a little study on DejaNews a large discussion (October 1999) about new
> > fmgr and functions which return tuples. (IMHO 'function' is not good name
> > for this, better is 'procedure'.)

Jan, thanks for answer, I thought that I again ask about bad matter or 
I send a stupid question :-) 

>     Here  again, the proposed overhaul of the parse-/querytree is
>     the reason why we don't want to tackle  this  issue  now.  At
>     that  time,  any  relation as well as a 'procedure' (function
>     returning a tuple set) will become a "tuple-source". A  tuple
>     source  is  mainly  an abstract node, describing the shape of
>     tuples it returns, hiding how it produces them to the caller.
> 
>     This  way,  there  is  no  fundamental  difference  between a
>     relation, a procedure or an external database link any  more.

Last weekend I a little explore current sources for this and the
current postgresql very "vegetates" on a relation and a example 
transform statement code very depend on relation structs. Yes,
Berkeley's code design for this is not modular and abstract.     

>     Up  to  now  we only have a vague idea in mind. And we're not
>     sure if we'll do this huge changes in the main CVS trunk or a
>     separate  branch.   Neither  have we decided when to start on
>     it, because we need a couple of key developers  at  the  same
>     time  to  ensure reasonable progress in that project (none of
>     us can do it alone).
> 
>     After 7.0 is out, I'll try to collect all the design  issues,
>     break up the entire package into smaller chunks and develop a
>     project plan for it.

Well.  
                    Karel 



pgsql-hackers by date:

Previous
From: Karel Zak
Date:
Subject: Re: caching query results
Next
From: Bruce Momjian
Date:
Subject: BSD/OS regression on 7.0