Re: R: feature proposal ...

On N, 2005-09-22 at 21:34 +0200, Hans-Juergen Schoenig wrote:
> absolutely - the main advantage of the syntax tweak is that you can  
> add parameters more easily.

Perhaps "COPY from SQL FUNCTIONS" is what wou need ?


Or should we piggypack on (future) work needed for hierarchical queries
and have "COPY from WITH" like this.

WITH copysource (f1,f2,f3) as (SELECT ... )
COPY copysource TO stdout;

The full syntax (as a railroad diagram) of WITH for hierarchical queries
is available at http://gppl.moonbone.ru/with_clause.gif .

But with can be used also for non-hierarchical queries, as kind of
inline temp view definition, and this copy syntax would be extension of
this use.


-- 
Hannu Krosing <hannu@skype.net>