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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
