Horton

Re: R: feature proposal ...

Hannu Krosing <hannu@skype.net>

View thread
From: Hannu Krosing <hannu@skype.net>
To: Hans-Juergen Schoenig <postgres@cybertec.at>
Cc: "Jim C. Nasby" <jnasby@pervasive.com>, Tom Lane <tgl@sss.pgh.pa.us>, Paolo Magnoli <pmagnoli@systemevolution.it>, pgsql-hackers@postgresql.org, eg@cybertec.at
Date: 2005-09-22T20:08:59Z
Lists: pgsql-hackers 
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>