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>