| From: | Tamas Nyitrai <defiant(at)telnet(dot)hu> |
|---|---|
| To: | PostgreSQL-General <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | GROUP BY problem with 6.5 |
| Date: | 1999-07-05 01:35:37 |
| Message-ID: | Pine.LNX.4.10.9907050335020.435-100000@defiant.telnet.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello!
I am using PostgreSQL 6.5 on a Debian/Linux 2.2 system. It all seems to
be just fine, but I have got into a problem with GROUP BY.
I have a query which worked OK until now (with all the previous versions
of PostgreSQL) but now it returns the following error message:
'Illegal use of aggregates or non-group column in target list'
So what has been changed at GROUP BY in 6.5?
Here is the whole query if you wish to take a look at it:
SELECT szl.*, sz.szaml_cim, sz.szaml_varos, sz.szaml_irsz, sz.szamlnev,
sz.programcsomagid, p.tulajdonosid
FROM dijbefizetesek szl, szerzodesek sz, programcsomagok p
WHERE (sz.szerzodesid = szl.szerzodesid)
AND (p.p_azonosito = sz.programcsomagid) AND (szl.osszeg > 0)
AND (szl.trdate >= 19990531) AND (szl.trdate <= 19990531)
AND (szl.trnum >= 1) AND (szl.trnum <= 1000) GROUP BY trdate, trnum
Thanking you in advance!
Regards,
Tamas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michal Maru¹ka | 1999-07-05 02:31:06 | Re: [GENERAL] Yet Another newbie not understanding why an index isn't used |
| Previous Message | Tamas Nyitrai | 1999-07-05 01:07:41 | GROUP BY problem with 6.5 |