Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA33367 for ; Thu, 25 Mar 1999 16:39:53 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id PAA28746; Thu, 25 Mar 1999 15:39:41 -0600 (CST) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma028578; Thu, 25 Mar 99 15:39:29 -0600 Received: by cpsmail.cpsgroup.com with Internet Mail Service (5.5.2448.0) id ; Thu, 25 Mar 1999 15:40:06 -0600 Message-ID: From: "Jackson, DeJuan" To: Oleg Bartunov , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Subselect has too many or too few fields Date: Thu, 25 Mar 1999 15:39:59 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id QAA33368 What are the results without the subselect? It looks like they will be what you are after. The problem is that you are grouping by a column that isn't in your specified result set. The way PostgreSQL deals with this little problem is by adding it to the retrieved rows, then using it in the group by and aggregating. Then just not displaying it on the print. DEJ > -----Original Message----- > From: Oleg Bartunov [mailto:oleg@sai.msu.su] > Sent: Thursday, March 25, 1999 10:53 AM > To: pgsql-sql@postgreSQL.org > Subject: [SQL] Subselect has too many or too few fields > > > I have a problem with query I thought must works: > > c_flats=> select source, max(up_date) as max_update, count(*) > from flats where u > up_date in (select max(up_date) from flats group by source) > group by source; > ERROR: parser: Subselect has too many or too few fields. > > Internal subselect produces as expected: > c_flats=> select max(up_date) from flats group by source; > max > ---------- > 15-03-1999 > 11-03-1999 > 24-03-1999 > 24-03-1999 > 24-03-1999 > > > And I don't see a reason my query doesn't works. > If I substite the result of internal subselect I get what I > need (there are > cyrillic characters in ) > > c_flats=> select source, max(up_date) as max_update, count(*) > from flats where u > p_date in > ('15-03-1999','11-03-1999','24-03-1999','24-03-1999','24-03-1999') gro > up by source; > source |max_update|count > --------------------------+----------+----- > éîëïí 369-00-25, 365-10-38|15-03-1999| 674 > ëÏÒÎÅÔ 912-00-12 |11-03-1999| 47 > íéáî 974-62-62 |24-03-1999| 393 > íéüìø 217-30-20, 217-39-13|24-03-1999| 1 > íãâî |24-03-1999| 141 > (5 rows) > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > >