Thread: RE: [HACKERS] GROUP BY fixes committed

RE: [HACKERS] GROUP BY fixes committed

From
Michael J Davis
Date:
I believe the insert statement below worked in 6.5 as of early April (before
4/5).  When I pulled new code toward the end of April it stopped working.

> -----Original Message-----
> From:    Thomas Lockhart [SMTP:lockhart@alumni.caltech.edu]
> Sent:    Monday, May 03, 1999 11:23 AM
> To:    Tom Lane
> Cc:    pgsql-hackers@postgreSQL.org
> Subject:    Re: [HACKERS] GROUP BY fixes committed
> 
> > Also, the problem Michael Davis reported on 4/29 seems to be in the
> > parser:
> > insert into si_tmpVerifyAccountBalances select invoiceid+3, memberid, 1,
> > TotShippingHandling from InvoiceLineDetails where TotShippingHandling <>
> 0
> > and InvoiceLinesID <= 100 group by invoiceid+3, memberid,
> > TotShippingHandling;
> > ERROR:  INSERT has more expressions than target columns
> > since that error message appears only in the parser.  Thomas, did you
> > change anything recently in parsing of INSERT ... SELECT?
> 
> Not that I know of. And I'm not sure what you mean by "recently". I've
> looked at the CVS logs but those don't help much because, especially
> for patches submitted by others, there is a generic description
> entered into the log which can't possibly describe the fixes in the
> particular file. *sigh*
> 
> Anyway, I'd lost the thread. Did Michael say that this is a
> recently-introduced problem?
> 
>                      - Tom
> 
> -- 
> Thomas Lockhart                lockhart@alumni.caltech.edu
> South Pasadena, California