On Mon, Aug 28, 2006 at 07:35:11PM +0200, Zoltan Boszormenyi wrote:
> >>COPY (SELECT ...) (col1, col2, ...) TO
> >>and it was actually working. In your v9
> >>you rewrote the syntax parsing so that
> >>feature was lost in translation.
> >Interesting. I didn't realize this was possible -- obviously I didn't
> >test it (did you have a test for it in the regression tests? I may have
> >missed it). In fact, I deliberately removed the column list from the
> >grammar, because it can certainly be controlled inside the SELECT, so I
> >thought there was no reason the support controlling it in the COPY
> >column list.
> Yes, it was even documented. I thought about having
> queries stored statically somewhere (not in views) and
> being able to use only part of the result.
ISTM that there should have been a regression test that tried that
capability out. That would have made it obvious when the functionality
was lost, at least.
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
In response to
pgsql-hackers by date
|Next:||From: Magnus Hagander||Date: 2006-08-30 17:46:25|
|Subject: Re: stats test on Windows is now failing repeatably? |
|Previous:||From: Tom Lane||Date: 2006-08-30 17:11:57|
|Subject: Re: [COMMITTERS] pgsql: Second try committing the path changes. |
pgsql-patches by date
|Next:||From: Christopher Browne||Date: 2006-08-30 17:50:44|
|Subject: BUG #2600: dblink compile with SSL missing libraries|
|Previous:||From: Bruce Momjian||Date: 2006-08-30 17:09:04|
|Subject: Re: [HACKERS] Interval aggregate regression failure|